Copy Data from One Group of Cells to Another Group

[Alan Auerbach]

I have five columns of data on two different sheets in the same workbook. One
set of columns is sorted in ascending date order the other in descending date
order. When I enter data into the last row of Sheet 1, I need the data in
that row in columns A, B, C and D to be copied into Sheet 2 columns A, C, D
and E in a newly inserted row 14. Is this possible with the use of a macro? I
can find the last cell in Sheet 1, but then need to go up one row and back to
column A. I am having difficulty with that.

Thanks is advance for any assistance offered!

/s/ Alan Auerbach

 

[Del Cotter]

I have five columns of data on two different sheets in the same workbook. One
set of columns is sorted in ascending date order the other in descending date
order. When I enter data into the last row of Sheet 1, I need the data in
that row in columns A, B, C and D to be copied into Sheet 2 columns A, C, D
and E in a newly inserted row 14. Is this possible with the use of a macro? I
can find the last cell in Sheet 1, but then need to go up one row and back to
column A. I am having difficulty with that.

This is microsoft.public.excel.charting. have you tried one of the other
excel newsgroups?

 

[Alan Auerbach]

Dear Del,

I am soooo dumb! Yes, of course this is the wrong group. :-( I simply went
to the wrong place by rote. Thank you for pointing that out.

Have you ever had to change your daily driving route to go somewhere else
and then fournd yourself at your normal destination rather than where you
wanted to go (I have!)? Thanks for waking me up!

Best wishes,
/s/ Alan Auerbach