Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a Summary from multiple worksheets
This is the first time I have posted on here so bear with me.....
I have a workbook, with 40 or so worksheets. All of the worksheets have the same information, in the same places. I want to pick out a summary of this information eg name, DOB, total charge and invoice number etc. onto one sheet into columns A,B,C etc in a nice neat little list. I have done this before in VBA but cannot for the life of me remember the wording (have not used VBA since). I do remember counting the columns as numbers so column F line 26 would be 6,26, but that is all. I am depseratly hoping that someone can help me because this is driving me nuts now! Thankyou so much in anticipation Regards Sandra |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help using data from multiple worksheets to create a Summary | Excel Discussion (Misc queries) | |||
Summary of multiple worksheets | Excel Discussion (Misc queries) | |||
Summary sheet for multiple worksheets | Excel Discussion (Misc queries) | |||
Summary sheet for multiple worksheets | Excel Programming | |||
Summary worksheet referencing multiple worksheets | Excel Worksheet Functions |