![]() |
copy cell info to other sheets, other sheets dont contain all row.
Hi
I have a worksheeet that i have been sent and I have to put pricing in column G I have done the main sheet, however there are eight other sheet with the same information asking for pricing but each sheet contains only selected rows from main sheet. Help I dont want to waste time manually typing in one eight sheets what I have already done on the main sheet |
copy cell info to other sheets, other sheets dont contain all row.
On Sat, 31 Oct 2009 15:55:01 -0700, Ja
wrote: Hi I have a worksheeet that i have been sent and I have to put pricing in column G I have done the main sheet, however there are eight other sheet with the same information asking for pricing but each sheet contains only selected rows from main sheet. Help I dont want to waste time manually typing in one eight sheets what I have already done on the main sheet Just EDIT HIS workbook, and be sure to save it as some other filename, and BOOM! You have done your cut and paste with a mouse click! Then you edit YOUR newly saved workbook again, and insert the column where desired. If you highlight ALL the tabs, you can add the column to all the worksheets at the same time, and in the same place, which may or may not work, depending on if the format of the sheets is consistent throughout. If not, add the columns one worksheet at a time. |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com