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

On Sat, 26 May 2007, in microsoft.public.excel.charting,
Alan Auerbach said:
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?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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

"Del Cotter" wrote:

On Sat, 26 May 2007, in microsoft.public.excel.charting,
Alan Auerbach said:
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?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.