Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert formula in multiple worksheets & copy output to new sheet
Hi Guys,
I have a macro that when excuted: - Formats a data sheet (inserting columns, vlookup from other files etc). - Autofiltering and copying unique values to different worksheets and renaming these sheets according to the unique value filtered (Thanks to Ron's code). I then add up these unique values to get a total in each sheet, which I transfer to a summary sheet. My problem is that every month I have different unique values, and hence have different number of sheets. Also in each sheet the number of rows defer, so putting a code in a specific line is also difficult. I was wondering if someone could help me write a code for (a). finding the totals for columns B - W in all sheets and (b). transferring it to a new summary sheet. Thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to copy multiple cells onto another sheet | New Users to Excel | |||
Multiple Worksheets and Cell References - Data Output | Excel Discussion (Misc queries) | |||
copy a formula into multiple worksheets and change 1 row down each | Excel Discussion (Misc queries) | |||
How do I copy a reference formula onto multiple worksheets | Excel Worksheet Functions | |||
formula from multiple worksheets to give a color output to one wo. | Excel Worksheet Functions |