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.
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")
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.
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.