Copied data not staying in same row

[tosteven]

Hello everyone.
I have a sheet of data that I fill and clear repeatedly. I would like to capture some of that data to a log sheet to maintain a history.
The attached spreadsheet functions 'almost' correctly.
The problem I am having is; if any of the cells are empty in the data it messes up the rows in the log sheet.
This is blender code, where I have taken code from multiple sources and tried to blend them together.

Questions:
How do I maintain row integrity when copying data to log sheet?
What is the purpose of the "a" in this line of code? ""LR = .Range("a" & Rows.Count).End(xlUp).Row)"" It seems like I can change it without affecting anything in the macro.

Functions:
Macro -When I enter the desired date, It should copy some of the data from "existing" sheet to "ExistingLog" sheet, and maintain row integrity.

Current Code:

Please Login or Register  to view this content.

I have attached a sample spreadsheet..

Thanks
tosteven

[JOHN H. DAVIS]

Not sure if this is what you mean, but try:

Please Login or Register  to view this content.

[tosteven]

Thank you John for the quick response.
I looks like the original code treats each column separately, if you enter 2/4/15 as the date in the original code, you can see the notes get offset in the log sheet.

It does seem to maintain row integrity now, but it is filling the same row in the log sheet as the original, rather than the next available row. Leaving empty rows in the log sheet. Additionally if I change the data in the existing sheet it will overwrite data in the log sheet..

-tosteven

[JOHN H. DAVIS]

I'm a bit confused. What do you mean by "row integrity"?

[tosteven]

when the data copies to the new sheet.
the data doesn't stay in the same row in the log sheet. because H5 is blank in the existing sheet, the data from H6 shifts up in the log sheet.
so in the sample data if you use 2/4/15 as the date,
data from existing A6, goes to Existing log A3. G6, goes to B3, F6 goes to C3; But H6 goes to D2 -because there is no data in existing H5.
So column D in the log sheet ends up out of sync with the rest of the row.

[JOHN H. DAVIS]

Now I think, I understand. Will the Asset# always have data (ie Never be blank?).

[tosteven]

yes, there will always be an asset number.
though that number could get duplicated, if the machine comes back to be reissued.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[tosteven]

Thanks John.
That appears to work perfectly.
I appreciate your time on it.
I can recognize that you have used the 'a' column to start the next row, great idea.
I'll have to dissect and understand what the whole line is doing.

Thanks a lot
Tom