Data Record

[gally]

I have this macro which auto records the value in Worksheet Horse G9 and then pastes the data every 1 second into row C of the worksheet Data Capture.

The first recorded value goes into C1 then one second later the newest recorded value goes into C2 then C3 and so on and so on.

I was wondering how I could change the code so the first recorded value goes into C1 then 1 second later the new value goes into C1 and the first value recorded moves down 1 row into C2 and then when another value is recorded it again goes into C1 the existing C1 becomes C2 and the C2 value becomes C3 and so on and so.

Please Login or Register  to view this content.

Thank you for looking.

Regards
Gally

[Deamo]

try this:

Please Login or Register  to view this content.

[gally]

Hi Deamo

What that is doing is still recording the macro as I had the macro originally set up but then pushing all the data down one row so in effect once its recorded 5 rows of data the first 5 rows are empty and then the next 5 have the data the way my macro was originally recording it, it's also over-riding the clock to auto update for some reason.

Thank you for the suggestion though.

Regards
Gally

[Deamo]

Can you post a copy of your spreadsheet?

Is pushing the exsting value in C1 down 1 row not what you wanted? or is the entire row to be moved rather than just column C?

[mike7952]

Try this

Please Login or Register  to view this content.

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[gally]

Hi Deamo I tryed posting a copy of the sheet but the file was to large.

Mike that code works.

Thank you both for taking the time to look and post some ideas

Regards

Gally