Ask a question Report

Transfer data between sheets in excel [Solved]

rodney hughes - Latest answer on Jul 30, 2015 01:37AM
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
Read more 
Answer
+38
moins plus
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
Add comment
Answer
+20
moins plus
Open both spreadsheets. In the spreadsheet where you want the information to appear click on that cell and enter the equal sign. Then go to the Windows tab and choose the other spreadsheet. Click on the cell that you want to import the information from. Then hit enter.

This should work. If you are using a new version of Office or Visio the tab maybe titled differently.
nkamo- Dec 17, 2014 01:46AM
u r a genius barbie! thank u
Reply
nim- Jan 8, 2015 03:19AM
I Want to sheet1 Data transfer Between sheet2 Using Macros....
Reply
dolfinstream- Jan 26, 2015 11:04AM
This worked good for me. Simple to do.
Reply
louise- Apr 24, 2015 08:42AM
I have tried = and then clicking on the cell on different sheet. I only get a 0.00 and not the figure already typed in the cell, please help! x
Reply
vcoolio 371Posts Thursday July 24, 2014Registration date ModeratorStatus September 1, 2015 Last seen - Apr 24, 2015 07:05PM
Hello Louise,

It would appear that your issue is somewhat different to the original Poster's. Please start a new thread so that it can be given the appropriate attention.

It would also be a good idea to upload a sample of your work book (be careful with any sensitive data) and to give us a solid explanation of what you would like to do and achieve. You can upload a sample by using a free file sharing site such as DropBox or ge.tt.

Thank you Louise.

Cheerio,
vcoolio.
(Moderator)
Reply
Add comment
Answer
+18
moins plus
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
thorshammer- May 1, 2011 11:16PM
No complicated situation to add to the above, just THANKS for the simple solution that works like a charm!
Reply
ham2023- Jul 30, 2015 01:21AM
hi

I have an excel data which is like my database, having all product information; name, cat. no., price, description. I want to link this excel to any new excel I create for Purchase orders, so I can retrieve the product information with just simple typing of product name.

Is there a way I can do this?

It will be of great help.

Thanks Much Guys.
Reply
vcoolio 371Posts Thursday July 24, 2014Registration date ModeratorStatus September 1, 2015 Last seen - Jul 30, 2015 01:37AM
Hello Ham,

For your request to receive the appropriate attention, it would be best to start a new thread. Please include a sample of your work book (be careful with any sensitive data) and offer a solid explanation of what you would like to do and achieve.
You can upload a sample by using a free file sharing site such as DropBox, SpeedyShare or ge.tt

Thank you Ham.

Cheerio,
vcoolio.
(Moderator)
Reply
Add comment
This document entitled « transfer data between sheets in excel » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.