Autofill 3 columns by matching master spreadsheet and another sheet

can you upload a sample workbook?

yes that can be done.

Hello,

I believe I have uploaded the sample spreadsheet.

Hello dmcgov,

Thank you. This performs exactly how I want, however, I would prefer it to be in the form of a macro rather than cell functions. Do you have ideas on how to take this logic and create a macro to do the exact same thing?

so you want a macro to do what? add a new row to weekly schedule and then fill out the columns? or add to your masterlist?

i don't understand why you want the macro as all you have to do is copy the formulas down in columns B,C,D,E. A is just a validated lookup from the masterlist. that way there is no coding to trip up the end user.

I don't want the user to have any formulas to potentially affect at all. That's why I want a macro running in the background.

I want to do exactly what your spreadsheet does except I want a macro running in the background rather than formulas on the spreadsheet itself.

ok, i have something in mind that i did a couple of weeks ago that might fit the bill. give me some time to come up with a solution.

ok, so here it is, please test sample2.xlsm to see if it does what you require

Note that i named the sheets("MasterList").Range("A2:D8") to .Range("MasterListParts"), also notice the blank row at the bottom of the named range. that is so you can insert rows into the range.

I put the validation list in column a to row 1000, just extend that if you need to go beyond that row.

also, clear the contents of weekly schedule (but preserve the label on row 1)

Thank you. This helps me so much.

if this fixed your issue, go to near the top of the post and click Thread Tools and Mark as Solved. Then (if i helped you) click on the Add Reputation in my post. I appreciate that.

i was able to put data validation in column "a" just by selecting a cell, if you want that functionality, let me know.