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? |
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 |
All times are GMT +1. The time now is 01:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com