Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
riley454
 
Posts: n/a
Default make multiple cells in 1 worksheet equal multiple cells in another

I need to assess data that I cut & paste from another format. To do so, I
must make cells in my own worksheets equal the cells that C&P items happen to
inhabit in Excel. I know how to make 1 cell equal another in a different
worksheet, but I have several adjoining cells(both in rows and columns) that
I would like to make equal to several adjoining cells in my own separate
worksheet so I can group and add formulas at my preference, from my own
worksheets. I could enter the simple "=Sheet2!B2" formula, but I have
potentially many hundreds of these cells to add them to.

How can I group certain cells to equal a group of similar cells in another
worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default make multiple cells in 1 worksheet equal multiple cells in another

Select the destination range (a range equal in dimensions to the input
range).
Enter =Sheet2!B2 and press Ctrl+Enter. The formula will be copied
throughout and the cell references will change accordingly.

Does this help?
Kostis Vezerides

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
how can i ignore blank cells when multiple cells? arash Excel Worksheet Functions 4 November 17th 05 05:35 PM
In Excel, how do you make one whole sheet equal to another. ryan Excel Discussion (Misc queries) 2 August 31st 05 07:03 PM
how do i maintain one worksheet from data from multiple worksheet Nensie Michel Excel Worksheet Functions 1 August 12th 05 06:32 PM
adding certain cells in multiple worksheets in multiple workbooks Stephen via OfficeKB.com Excel Worksheet Functions 1 February 4th 05 09:31 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 05:23 PM


All times are GMT +1. The time now is 10:10 AM.

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

About Us

"It's about Microsoft Excel"