Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy cell between sheets | New Users to Excel | |||
Match Names in columns then copy associated info from 2 sheets | Excel Worksheet Functions | |||
How can I match up values from 2 sheets and info in adjoining cell | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Copy info from worksheet 1 to other sheets | Excel Worksheet Functions |