Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining worksheets and lookups
I have a workbook # 511 with 7 sheets. I want to copy the following 6 sheets to sheet 7 sheets("Sheet1").Select Range("A5:Q58") Sheets("Sheet 2").Select Range("A5:Q58") Sheets("Sheet 3 ").Select Range("A5:Q38") Sheets("Sheet 4 ").Select Range("A5:Q25") Sheets("Sheet 5 ").Select Range("A5:Q35") Sheets("Sheet 6 ").Select Range("A5:Q25") 3 questions; Exactly how do I do this so that changes made to any sheet is also reflected on Sheet 7 (TOTALS_PAGE) How can I make the current column D for instance be based on a past workbook from last weeks's cloumn P ( NOT d ) Each workbook is named with a number based on the last number used. This is 511 last week was 510 etc. How do I have either VBA or a macro automatically look and use that number to find the last workbook. Cell C 1 always contain the name/number of the current workbook on each worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheets lookups | Excel Worksheet Functions | |||
Lookups across worksheets | New Users to Excel | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Copying data within worksheets with lookups | Excel Discussion (Misc queries) | |||
lookups in other worksheets.... | Excel Programming |