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 :
Transfer data from Excel and Access into MySQ Show
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...
Saving data in excel with vb Show
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[Windows XP ] Transfering files via Bluetooth Show[Windows XP ] Transfering files via Bluetooth Implementation: Accessing the utility: Transferring Data Windows XP possess a interesting utility that allows you to transfer data via Bluetooth. It is very handy if you want to send...
Connecting two computers with a USB cable. ShowConnecting two computers with a USB cable. What to choose? How does it work? What to do? If you have to transfer huge files from one PC to another, using a flash disk or burning a CD-ROM can seem like a waste of time. One wise way...
Download Excel Viewer Show
Download SSH Secure Shell ShowSSH secure shell for workstations is a flexible client SSH allowing to connect in a secured way to remote applications. http://www.commentcamarche.net/faq/images/NHc6wz5jOYBhPXTis.png
Download MI Contacts Exporter Show
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
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...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

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

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
  • +33

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