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

H

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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
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?
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
How to automatically update a master table with tables from other worksheets ?
Replies
0
Views
218
Andre989
A
T
  • Question
How to show Msg if Record not found in table
Replies
3
Views
104
myall_blues
myall_blues
A
  • Question
Worksheet from a template using a master list but protecting existing worksheets
Replies
0
Views
238
Alfalfa166
A
S
  • Question
For Loop with If Statement Assistance
Replies
0
Views
239
smick
S
U
  • Question
Information overwriting when transferring
Replies
7
Views
273
UTB
U

Forum statistics

Threads
1,215,220
Messages
6,123,697
Members
449,117
Latest member
Aaagu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top