How to Create a macro to copy over multiple cells in a certain row based on a cells value

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

here is some theory and a little code to get you started...... not sure if you have started anything yet or how familiar you are with vba so here goes nothing

put all the data into variables (standard procedure)
Loop through the table holding the data you want to transfer first
inside this loop, loop through the other table and check if the record exists (or forget this loop and just remove duplicates later up to you)
if your clear to add the record check the column you needed to check if its resignation put resignation, if not put term...
finished....

Please Login or Register  to view this content.

Sorry about the formatting, this will give you something to play with anyway, its using arrays and rngs so you can see how they work..

Thanks
Paul S.