Macro does not consistently paste data in the right row

[nugundam93]

Hi All,

I'm currently having an issue with the macro I did where it will correctly paste answer selections (such as Yes/No/NA) into the right row, but it will not paste the corresponding comment into the correct row and it would always instead paste it into the 1st row. For example - 1st data entry will correctly paste everything into the 2nd row of the data tab (1st row is reserved for each item's name). 2nd entry will paste the answer selections into the 3rd row as expected, but the comments for that 2nd entry will paste the comments into their corresponding columns, but will overwrite the comments data of the 1st entry. 3rd entry will also do the same - it will correctly paste the answer selections into the 4th row, but the comments will get pasted again into the comments data in row 2, overwriting again whatever's previously listed there.

I'm attaching the sample code here. New_Form refers to the tab of the actual worksheet, while Data refers to the data dump tab.

Thanks in advance!

[Mumps1]

Could you attach a copy of your file? Explain in detail what you want to do using a few examples from your data and referring to specific cells, rows, columns and sheets. De-sensitize the data if necessary.

[banaanas]

Please attach your workbook instead This will be difficult without it!

[nugundam93]

Apologies to all. Attaching a de-sensitized version of the sheet. Don't mind the dropdowns on some.

Thank you again.

[Mumps1]

The copy of the file you posted has no data so it is hard to test a possible solution. Also, you want to copy data from Columns J and K and cell I2 but these don't have any data either. Could you post a copy of your file that includes the data to make it easier to test a macro?

[nugundam93]

Uploading an updated attachment.

Going to the data tab, row 4 is scoring for the 1st evaluation (call ID 123456789), row 5 is the scoring for the 2nd evaluation (call ID 987654321). The behavior is that the scores for the 2nd eval is saved correctly to the correct row, but the comments for the 2nd eval gets saved where the comments for the 1st eval is.

New_Form (2) is the duplicated 2nd eval to show the comments and the comments in the data tab was saved in the wrong row.

Thanks.

[Mumps1]

Try:

Please Login or Register  to view this content.

[nugundam93]

awesome, works perfectly. Thank you so much, highly appreciated!

[Mumps1]

You are very welcome.

[nugundam93]

Apologies on the thread necromancy, but I just added a few rows to the New_Form tab and made the appropriate mapping changes on the macro, and while that's already done, it now overwrites the info saved to the Data tab.

For example, eval 1 should save in row 4 of the Data tab as that's the 1st blank row, and eval 2 should save in row 5. That was the old behavior but post-update, it just keeps overwriting the data in row 4.

I've already copied and pasted Mumps' macro above but to no avail.

Anything I might have missed out or accidentally deleted?

Thanks!

[romperstomper]

It would probably help if you posted the changed code. Best guess would be that you're using the wrong column to find the output row.

[Mumps1]

Please attach a copy of your updated file.

[nugundam93]

Apologies, here's the file.

Thanks!

[romperstomper]

You appear to be copying a lot more rows from some columns than others. Since the code uses column A to determine the next blank row, and column A is not the most populated column, you will naturally end up overwriting data. Use a different column.

[nugundam93]

hi rorya: let me check that again since i'm sure that issue of copying more columns is already okay. the problem is it keeps overwriting existing rows in the raw data's tab. so instead of me having a running raw data starting from row 4 up to how many I've done, it just keeps overwriting data that's already on row 4.

[romperstomper]

That's what I'm saying. Your code copies about 10 rows from column E to column A, but it copies a lot more rows from some of the other columns, meaning column A on the data sheet is blank for those additional rows. The code uses column A to determine the next blank row, which then means you get data overwritten. You need to either use the column you copy most rows from to determine the next blank row, or use a loop (or Find operation) and find the last populated row on the data sheet.

[nugundam93]

i redid the mapping and now it works. thanks!