Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JA JA is offline
external usenet poster
 
Posts: 13
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 277
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cell between sheets Rev. Michael L. Burns New Users to Excel 6 March 20th 09 12:54 PM
Match Names in columns then copy associated info from 2 sheets Seantastic Excel Worksheet Functions 4 October 29th 08 08:29 PM
How can I match up values from 2 sheets and info in adjoining cell naclu Excel Discussion (Misc queries) 4 February 3rd 06 10:50 PM
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? Daniel Excel Worksheet Functions 1 July 6th 05 09:57 PM
Copy info from worksheet 1 to other sheets John Excel Worksheet Functions 2 February 12th 05 07:43 PM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"