I have been researching ways to copy data when conditions are met and to copy specific ranges to specific places on separate worksheets but I can't put them into one Macro to do everything.
My situation is I have a spreadsheet which has many tabs each a different code, every month I copy data from a report on a separate document and distribute the data to the correct tab based on the code. I have included two screenshots to show the layout of the spreadsheet which I hope provides a little more clarity.
I would like to be able to copy the whole report each month onto tab "Transaction Report", then press a button which searches the codes listed in Column A, It then copies the rows of data between columns B:I (not the whole row) and then distributes them to their corresponding code tab, pasting them in columns Q:X.
I don't know if it would need additional code to clear any previous data in columns Q:X in each tab before pasting new data so as not to have duplicated data. There is other data on each tab so only the range can be deleted.
I appreciate now writing this that it seems I may be asking a bit much but any help would be much appreciated.