Macro assistance needed for complex export/import excel file

I am currently exporting a file from my database, then manually filtering and replacing things. I am still working on building my knowledge base on how to use VBA and Macros and I know i have a long way to go.

I am uploading a sample document that has three workbooks. Workbook 1 is how it looks when its finished and ready for uploading. Workbook 2 is the data i get from my SIS database, and workbook 3 is an empty template.

I know can bring over columns A,B,C,D, and E on Workbook 1 without a problem as those are static fields that never change. The hard part (for me) is filling in G, I, J, K, M, N based on the value of WorkBook 2's Column G.

I Assume that I need to do an If G contains "Rad HR2" then ... statement for these?

Any assistance with furthering my knowledge will be appreciated

Thank you

Don.

Thats the problem when you spend soo much time in these excel documents. you forget that no one else can peak into your brain

I have created a new tab called "The Mystery of G" with colomn A being the value of the export file and GIJKMN with the associated values.

Thank you for any assistance

Don.

Originally Posted by mike7952

Will all this data be in 1 workbook? Or are these 3 different workbook?

Yes all goes into Work Book 1. The data pulls from the workbook titled nwea export for upload), and the other two (Mystery of G, Empty Template) are my visual references

Thank you

Don.

Hmm last upload was the wrong file.

here is this one. This is the correct one.xlsx

You are awesome!! Thank you! The Macro worked perfectly, I was able to enter the two columns i needed and transfer it to the CSV and it uploaded seamlessly. AND it found three errors that the past manual input file had!

THANK YOU!!!!

Don.