Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for accounting month to each spreadsheet?
I have about 50-60 spreadsheets that I only want to put the
March 2007 on one of the spreadsheets - How do I get it to copy to the other spreadsheets without putting it on every single spreadsheet? any help is greatly appreciated!!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for accounting month to each spreadsheet?
I don't understand what you mean, what exactly is it that you want to do?
-- Regards, Peo Sjoblom "Jane" wrote in message ... I have about 50-60 spreadsheets that I only want to put the March 2007 on one of the spreadsheets - How do I get it to copy to the other spreadsheets without putting it on every single spreadsheet? any help is greatly appreciated!!! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for accounting month to each spreadsheet?
I'm sorry, I'm new.
ok, I have several worksheets (a, b, c., etc.)in a workbook and I put info in the worksheet A then instead of having to put it on b and c worksheets how do I make it copy the info from cells in worksheet A to b and c as it would do it automatically? I don't want to have to copy and paste 50 times but I don't know how to make worksheet b, c copy some of the info from just a few cells from worksheet a. I hope this makes sense. Thank you! "Peo Sjoblom" wrote: I don't understand what you mean, what exactly is it that you want to do? -- Regards, Peo Sjoblom "Jane" wrote in message ... I have about 50-60 spreadsheets that I only want to put the March 2007 on one of the spreadsheets - How do I get it to copy to the other spreadsheets without putting it on every single spreadsheet? any help is greatly appreciated!!! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for accounting month to each spreadsheet?
If these are sheets in the same workbook, click the sheet tab of the first
worksheet where you want to type the text, then hold down shift and click the last sheet tab, now select the cell where you want the text in the first sheet and type it and press enter, finally right click any of the grouped sheet tabs and select ungroup. That should be it -- Regards, Peo Sjoblom "Jane" wrote in message ... I'm sorry, I'm new. ok, I have several worksheets (a, b, c., etc.)in a workbook and I put info in the worksheet A then instead of having to put it on b and c worksheets how do I make it copy the info from cells in worksheet A to b and c as it would do it automatically? I don't want to have to copy and paste 50 times but I don't know how to make worksheet b, c copy some of the info from just a few cells from worksheet a. I hope this makes sense. Thank you! "Peo Sjoblom" wrote: I don't understand what you mean, what exactly is it that you want to do? -- Regards, Peo Sjoblom "Jane" wrote in message ... I have about 50-60 spreadsheets that I only want to put the March 2007 on one of the spreadsheets - How do I get it to copy to the other spreadsheets without putting it on every single spreadsheet? any help is greatly appreciated!!! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for accounting month to each spreadsheet?
Terrific!!!! it worked! thank you so very much!!!
"Peo Sjoblom" wrote: If these are sheets in the same workbook, click the sheet tab of the first worksheet where you want to type the text, then hold down shift and click the last sheet tab, now select the cell where you want the text in the first sheet and type it and press enter, finally right click any of the grouped sheet tabs and select ungroup. That should be it -- Regards, Peo Sjoblom "Jane" wrote in message ... I'm sorry, I'm new. ok, I have several worksheets (a, b, c., etc.)in a workbook and I put info in the worksheet A then instead of having to put it on b and c worksheets how do I make it copy the info from cells in worksheet A to b and c as it would do it automatically? I don't want to have to copy and paste 50 times but I don't know how to make worksheet b, c copy some of the info from just a few cells from worksheet a. I hope this makes sense. Thank you! "Peo Sjoblom" wrote: I don't understand what you mean, what exactly is it that you want to do? -- Regards, Peo Sjoblom "Jane" wrote in message ... I have about 50-60 spreadsheets that I only want to put the March 2007 on one of the spreadsheets - How do I get it to copy to the other spreadsheets without putting it on every single spreadsheet? any help is greatly appreciated!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Month-end accounting balance out | Excel Worksheet Functions | |||
help creating a accounting spreadsheet for a daycare center | Excel Discussion (Misc queries) | |||
I need an Excel Spreadsheet for Cafeteria Plan Accounting. | New Users to Excel | |||
how do i do an accounting spreadsheet | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions |