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?
Bookmarks