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

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!

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

"cahabbinga" wrote:

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!

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

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

"cahabbinga" wrote:

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!

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

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

"KGEORGE" wrote:

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

"cahabbinga" wrote:

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!

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

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

"cahabbinga" wrote in message
...
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

"KGEORGE" wrote:

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

"cahabbinga" wrote:

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!

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

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!




"David Biddulph" wrote:

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

"cahabbinga" wrote in message
...
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

"KGEORGE" wrote:

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

"cahabbinga" wrote:

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!

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

Try it like this in A4:

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

and then just copy it down as required.

Hope this helps.

Pete

On Jan 30, 12:50*pm, cahabbinga
wrote:
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!



"David Biddulph" wrote:
You've probably got the cell containing your formula formatted as text.
Format as General, then use F2, Enter.
--
David Biddulph

"cahabbinga" wrote in message
...
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

"KGEORGE" wrote:

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

"cahabbinga" wrote:

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!- Hide quoted text -

- Show quoted text -