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.