Hi there,

I haven't been involved in in-depth formulae or macros since studying IT at school and need a little help.

I believe I need to add a macro or VBA. Essentially, I have a workbook which asks as a master 'lookup'/reference point and contains all items sold to customers. This ranges from Column B - Column M and will be continually updated, so there is no definitive end line on the data I need to pull from.

From this data, I need to complete multiple additional workbooks, pulling rows from the master workbook, but only copying specific rows of data, based on a criteria. For example; I would like to be able to complete 1 new workbook, which has multiple worksheets, pulling the information and pasting this based on the customer stock has been sold to. For example; the customer name I want to use is Costco, which is in column F. If column F contains 'Costco' I want to copy that row of data, into the new workbook. Each tab would then follow the same method, but would be determined by the different customer names - of which there are between 8-10

I really hope someone would be able to help me on this and welcome your feedback/advice