Forum Discussion
Help with creating a loop to backfill data from one sheet to another
Hi, I have values in this "Sample Analysis Data" sheet in cells B2:B10. The code then looks for that value in the sheet "Meta Data". It then copies the cells in that row and pastes it in "Sample ...
Saw your message yesterday. Took your code and changed it a bit. When I was ready to post it, your message had disappeared. Now I see you added a workbook and changed some of the code.
The solution I created yesterday will work as long as your first sample cell is B2, and I believe the code in the attached workbook will do the trick for you, but you'll need to amend it to make it work in yours. Perhaps you need to change the structure of your meta data so that the Sample Name is in the first column. You want to delete column A as well.