copy parts of different cells into new cell


J

jef

I have multiple rows of data with several columns, each row being data
on a specific customer. I want to copy several cells of data from a
specific row in a sheet to a different sheet (within same
spreadsheet), the purpose being to isolate some of the data for a
specific customer on one page/sheet (the different sheet within the
same spreadsheet).

The sheet with the data is named, Data. Thus, to copy the contents of
cell C32 from the Data sheet to a cell in the separate sheet would be
=Data!C32. I might have a dozen or so of these cells to copy. Simple
enough. However, when I want to see the same data on a different
customer, say the customer in Row 45, I have to manually change all
dozen copy commands; that is for the example above, to =Data!C45.

I am looking for a more automated and seamless method. What I thought
of was to use the partial copy command (that is in the above example,
=Data!CX, where “X” is the row number located in a separate cell on
the 2nd sheet to be gatherer from another cell), and concatenate it
with a cell on the 2nd sheet that contains just the row number. This
way, I can simply change the cell on sheet two that contains the row
number only, and all dozen cells on the 2nd sheet will change to the
correct row and column number from the Data sheet.

I have actually gotten the concatenate function to produce the desired
result – EXCEPT the result is in “text” format only, meaning that it
appears the concatenate function outputs in text and will not produce
a “copy” command formula.

Any thoughts from anyone would be greatly appreciated.
 
Ad

Advertisements

D

David Heaton

I have multiple rows of data with several columns, each row being data
on a specific customer.  I want to copy several cells of data from a
specific row in a sheet to a different sheet (within same
spreadsheet), the purpose being to isolate some of the data for a
specific customer on one page/sheet (the different sheet within the
same spreadsheet).

The sheet with the data is named, Data.  Thus, to copy the contents of
cell C32 from the Data sheet to a cell in the separate sheet would be
=Data!C32.  I might have a dozen or so of these cells to copy.  Simple
enough.  However, when I want to see the same data on a different
customer, say the customer in Row 45, I have to manually change all
dozen copy commands; that is for the example above, to =Data!C45.

I am looking for a more automated and seamless method.  What I thought
of was to use the partial copy command (that is in the above example,
=Data!CX, where “X” is the row number located in a separate cell on
the 2nd sheet to be gatherer from another cell), and concatenate it
with a cell on the 2nd sheet that contains just the row number.  This
way, I can simply change the cell on sheet two that contains the row
number only, and all dozen cells on the 2nd sheet will change to the
correct row and column number from the Data sheet.

I have actually gotten the concatenate function to produce the desired
result – EXCEPT the result is in “text” format only, meaning that it
appears the concatenate function outputs in text and will not produce
a “copy” command formula.

Any thoughts from anyone would be greatly appreciated.

Jef,

Try this

=INDIRECT("Data!C" & $A$1)

where A1 contains the number of the row you want to interrogate in
your Data sheet.

Regards

David
 
J

jef

Jef,

Try this

=INDIRECT("Data!C" & $A$1)

where A1 contains the number of the row you want to interrogate in
your Data sheet.

Regards

David

David - Thanks a lot. Worked perfectly.

jef
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top