Copy range to next available rows.

[matkyne]

Hi, I have searched for answers on this problem before but I can't seem to apply the other examples to my very simple problem.

I am making a spreadsheet for my mother to help her track her weight loss.

on Sheet1, I have a table set up so that the current date is listed in A2 (with the TODAY() formula) and B2 is where she can input her current weight.

On Sheet5 I have a table set up with all the past information, Dates in column A and the corresponding weights in column B.

This information is used in a chart that continually updates so she can see her progress over time.

In an effort to make this as easy as possible for her to use, I would like to set up a macro that will copy the values from Sheet1, (A2:B2) and paste values and number formats onto the next available row on Sheet5 (AX:BX).

I feel like this should be easy to do but I just can't seem to get the verbage right. Thanks in advance for your help.

[DonkeyOte]

Along the lines of:

Please Login or Register  to view this content.