Search : in
By :

Transfer data between sheets in excel

Last answer on Sep 22, 2009 12:50:11 pm BST rodney hughes, on Sep 27, 2008 11:45:58 am BST 
 Report this message to moderators

Hello,

This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab containing the students names and the monthly totals.
I would like to transfer students' names and the monthly totals associated with each name to a summary sheet.

If you would like the exact attendance sheet, I can send that along.

Thanks,

rodney

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « transfer data between sheets in excel » in :
Transferring data from one hard drive to another Show Transferring data from one hard drive to another First of all you should use some tools.. transfering data from one hard drive to another is quite simple. Once you have connected the new hard drive to your pc, check your...
Transfer data from Excel and Access into MySQ Show
Comparing and extracting data in Excel Show
[Facebook]b.static.ak.fbcdn.net Show[Facebook]b.static.ak.fbcdn.net When you're on Facebook, the status bar of the browser displays consistently one of the following messages: Transfer data from b.static.ak.fbcdn.net Pending b.static.ak.fbcdn.net...
VBA: Finding Hdc in an Excel worksheet or UserForm ShowVBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download Excel Viewer Show
Download Access Data Transfer Assistant 2000 ShowAccess Data Transfer Assistant 2000 is a program which allows you to transfer data between two Access databases. It lets you add data to the existing data of the destination database or to replace the data by those from the source database. It...
The HTTP protocol ShowIntroduction to the HTTP protocol Since 1990 HTTP protocol (HyperText Transfer Protocol) has been the most widely used protocol on the Internet. Version 0.9 was only intended to transfer data over the Internet (in particular Web pages written in...
FTP protocol (File Transfer Protocol) ShowIntroduction to FTP protocol FTP protocol (File Transfer Protocol) is, as its name indicates a protocol for transferring files. The implementation of FTP dates from 1971 when a file transfer system (described in RFC141) between MIT machines...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
Ask your question Reply

1

Ken, on Feb 10, 2009 5:26:20 pm GMT
  • +38

Hi

I need attendace sheet on Montly can any one help me

   
Reply to Ken

2

Will, on Mar 16, 2009 12:44:47 pm GMT
  • +34

Hi i need a VBA Code to automatically copy data from Sheet1 to Sheet 2. But only cells with a number greater than 0 and see example
Column 1 Column 2 Column 3 on Sheet 1 when on sheet 2 i want Column 1 with data from column 2 and on Column 2 of Sheet 2.

Any help will be appreciaed.

   
Reply to Will

3

rob, on Jun 19, 2009 8:54:14 pm BST
  • +1

Looking for something similar. Were you able to figure it out? pls email me at robolson15@hotmail.com if you can help...

   
Reply to rob

4

Sunil, on Sep 6, 2009 12:08:01 pm BST
  • +2

You can try this

Private Sub CommandButton1_Click()

Dim C As Long
Dim Cell As Range
Dim NextRow As Long
Dim Rng As Range
Dim EntryWks As Worksheet
Dim DBWks As Worksheet
C = 1
Set EntryWks = Worksheets("Sheet1")
Set DBWks = Worksheets("Sheet2")
Set Rng = EntryWks.Range("B6:ad6")

NextRow = DBWks.UsedRange.Rows.Count
NextRow = IIf(NextRow = 1, 1, NextRow + 1)

For Each RA In Rng.Areas
For Each Cell In RA
C = C + 1
DBWks.Cells(NextRow, C) = Cell
Next Cell
Next RA
End Sub

   
Reply to Sunil

5

 shaude, on Sep 22, 2009 12:50:11 pm BST
  • +2

Help!!!! this what I have. I have a work book with several tabls each tab represents a week day (example: Monday, Tuesday, and so on) Each day is a work sheet filled with formulas of time turned into hours worked with a total cell at the bottom.

What I am trying to do on another work sheet is make a table that say anlong the top the weeks such as 9/11/09, 9/18/09 and so on with the days of the week running down the left saying Monday, Tuesday, Wednesday, Thursday and Friday.

I want the totals from the tabed weekdays to automatical fill into the new sheet.


Can some one please help me with this????

Thank you

   
Reply to shaude
Ask your question Reply
They need your help