ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   copy cell info to other sheets, other sheets dont contain all row. (https://www.excelbanter.com/excel-worksheet-functions/247145-copy-cell-info-other-sheets-other-sheets-dont-contain-all-row.html)

JA

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


CellShocked

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