copy data of two cells from Sheet 2 into one cell in Sheet 1

[cahabbinga]

I have a workbook with multiple sheets, the first sheet is a summary sheet.
I'm trying to copy data from two separate cells in one sheet to one cell in
the summary sheet.

CLARIFICATION: From Sheet 2 I have data in cells K33 & K34. I need to have
the data from both of these cells automatically copy into cell Q28 on the
summary sheet.

DATA from cell K33 -- N3/12;
DATA from cell K34 -- cldy;rn

So that cell Q28 will read N3/12;cldy;rn

Can someone please help me out with this... Thank you!

 

[KGEORGE]

I have a workbook with multiple sheets, the first sheet is a summary sheet.
I'm trying to copy data from two separate cells in one sheet to one cell in
the summary sheet.

CLARIFICATION: From Sheet 2 I have data in cells K33 & K34. I need to have
the data from both of these cells automatically copy into cell Q28 on the
summary sheet.

DATA from cell K33 -- N3/12;
DATA from cell K34 -- cldy;rn

So that cell Q28 will read N3/12;cldy;rn

Can someone please help me out with this... Thank you!

 

[KGEORGE]

=CONCATENATE(Sheet1!K33,";",Sheet1!K34)

 

[cahabbinga]

I've tried this already... Sorry, but when I type the formula into the cell,
it remains as a formula??? It doesn't import the data as it should... This
was the same problem I was having to start with... I can't figure it out...
Any thoughts?? Could there be something wrong with the destination sheet
that the data won't import?

Also, I had to track this discussion group down... The email that was sent
to me did not work properly... When I clicked on the link " Read and rate
the response" all I got was a blank window???

Thanks again...

Cynthia

 

[David Biddulph]

You've probably got the cell containing your formula formatted as text.
Format as General, then use F2, Enter.

 

[cahabbinga]

THAT WAS IT!! I knew you guys would know, thanks so much...

I do have one more issue I'd like help with. On the summary sheet, each row
inputs information from a different sheet in the work book. I have a
separate sheet for each day of the month -- 1 through 31. Each 'day' sheet
has the same info in it for that specific day of the month. I need for the
data input in the summary sheet, FOR EACH COLUMN, to input the same
information from each individual day sheet.
How do I copy the formula in decending cells so that it will CHANGE THE
SHEET REFERENCE, BUT KEEP THE SAME CELL REFERENCE?

EXAMPLE:
In Column A of the summary sheet, I need A4 to be
=CONCATENATE(Sheet1!K33,";",Sheet1!K34)

But in Column A, cell A5, I need for the formula to be
=CONCATENATE(Sheet2!K33,";",Sheet2!K34)

Column A, cell A6 -
=CONCATENATE(Sheet3!K33,";",Sheet3!K34)

excetera... excetera... excetera...

Thanks again!

 

[Pete_UK]

Try it like this in A4:

=INDIRECT("Sheet"&ROW(a1)&"!K33")&";"&INDIRECT("Sheet"&ROW(A1)&"!K34")

and then just copy it down as required.

Hope this helps.

Pete