|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Master sheet to split sheets back to another master sheet
I am new to Excel and VBA, i have a question pertaining to the split
I have a output file called output, my wkb has one sheet/tab called
I have a macro to pull in the output file and add it to the workbook.
my wkb now has 2 sheets/tabs.
OUTPUT and MIS
i have a macro that has split that 'output' sheet into many sheets
given a unique value in the output sheet. It is actually the
department, so i have multile sheets that have the different depatments
in one workbook.
the tabs could be as follows...
output / MIS / 01-210 / 01-215 / 01-220 /..etc/ (could be 20
departments,it just depends on who ran the report to get the output
Now, the MIS sheet is still blank...
The users can make adjustments to their department sheets, i have a
diolog box that has a button.
I want that button to take ranges from the department sheets and put
them into the MIS master sheet.
The ranges of each sheet will be the same columns but the amount of
rows will change.
So i would copy:
All the sheets (depts- 01-210,01-215,01-210,etc...) will use columns
A,F,G,H,I,J ,but won't know how many rows.
and then paste to the MIS sheet
to the colums A:F
[I have tried doing the recorder but I can't do that since i won't know
exactly what the tabs or departments will be until i split the sheet.
multiple people will use this and the departments will be different for
each one doing the splitting. ]
I hope that i am explaining myself okay...so now...i am stuck, i don't
know the tab or department until its made, so how can i automate this?
Thank you for taking the time to help me out here, since i am new. Any
help would really be appreciated.
|Thread||Thread Starter||Forum||Replies||Last Post|
|Paste all sheets into one master sheet||Its me[_3_]||Excel Worksheet Functions||5||August 3rd 09 03:30 AM|
|Generating Master sheet from child sheets||Sundar||Excel Discussion (Misc queries)||3||June 11th 08 09:43 PM|
|Updating indivudal sheets thru a Master sheet||Bob||Excel Discussion (Misc queries)||3||March 13th 08 04:46 PM|
|Moving data from master sheet to new sheets||Midget||Excel Worksheet Functions||8||May 8th 07 03:33 AM|
|Getting info from individual sheets into master sheet||[email protected]||Excel Discussion (Misc queries)||1||November 17th 06 05:24 PM|