Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
universal copying over worksheet range
I produce invoices for piano students in excel and so have 40 or so
worksheets per file. I invoice per term and sometimes need to put on additional info. what i want to know is how do i say change the term dates on the first worksheet and have said dates be copied to all other worksheets without opening worksheets and pasting 40 odd times? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
universal copying over worksheet range
If the cells that get changed are the same (all A1 or all X99), then you can
group the sheets. Select the first sheet and ctrl-click on subsequent (or rightclick on any tab and choose Select All) Then the changes you make to a cell on any of those grouped sheets is changed on the other sheets in the group. You'll want to ungroup when you're done--it can be dangerous. Remember to look at the title bar. You'll see [Group] to remind you that some sheets are grouped. pat in chard wrote: I produce invoices for piano students in excel and so have 40 or so worksheets per file. I invoice per term and sometimes need to put on additional info. what i want to know is how do i say change the term dates on the first worksheet and have said dates be copied to all other worksheets without opening worksheets and pasting 40 odd times? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Universal formula to all cells | Excel Worksheet Functions | |||
Copying cell with input range to different worksheet | Excel Worksheet Functions | |||
Universal Chart and Indicator Worksheet | Excel Discussion (Misc queries) | |||
Universal formulas for any given row | New Users to Excel | |||
Make A Universal Time Converter | New Users to Excel |