How to splip information from a Master worksheet to several separate worksheets

hunycombs

New Member
Joined
Apr 22, 2010
Messages
7
I have this project that has approximately 30 worksheets. I also have a main worksheet that summarizes all the information totalled on each spreadsheet. Is there a way input the info on the main summary page and the information get transferred "automatically" to each approapriate worksheet??? Thanks
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Simon Lloyd

Well-known Member
Joined
Sep 10, 2006
Messages
756
we need more information than that, where will the new info be inserted? what's the layout? is the new info to populate certain cells on one of the other sheets or a whole new row?
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,952
Messages
5,508,331
Members
408,680
Latest member
Daven13

This Week's Hot Topics

Top