Macro to copy values to worksheets based on value

[cjlaing]

Hi

I am looking to write a macro where it takes the information from the 1st sheet and copies it out to the appropriate worksheets when I run the macro. I am looking to move them out into worksheets named after contract numbers 8060, 8290, 8483 as examples. There will be a column in the front sheet that states the contract.

Any help would be much appreciated.

Thanks

CJ

 

[dmt32]

It is working yeah. Thanks a lot!

glad we got there & all ok.

Many thanks for pressing the Thanks / Likes buttons on my posts - it is very much appreciated.

Dave

 

[My Aswer Is This]

It would be nice if you would share with us the final code which worked. I have been following this thread and would like to see the script which worked.

 

[dmt32]

It would be nice if you would share with us the final code which worked. I have been following this thread and would like to see the script which worked.

You can find the original code here:Copy rows of data from one sheet to another based on value in a column on the first sheet
see post #2

All OP has done is to delete the inputbox part - hard code Header Row & Filter Column. Also the row to paste to in destination sheet.
rest of code is, as far as I am aware, unchanged.

Dave

 

[My Aswer Is This]

That's Ok. I just wanted to see the final code posted here. But...

You can find the original code here:Copy rows of data from one sheet to another based on value in a column on the first sheet
see post #2

All OP has done is to delete the inputbox part - hard code Header Row & Filter Column. Also the row to paste to in destination sheet.
rest of code is, as far as I am aware, unchanged.

Dave