Hi All
I have a supplier product data workbook containing over 10,000 different product rows. I wish to create an additional worksheet which contains only the product rows of the products I have in stock. This is only 150 rows and I would like to just highlight the row in the master worksheet and for that row to be automatically copied to the secondary "in stock" worksheet. Can this be done? I could create an additional column in master worksheet with 0 or 1 switch (0=not stocked, 1 = stocked)
Many thanks for any help. Regards Simon
I have a supplier product data workbook containing over 10,000 different product rows. I wish to create an additional worksheet which contains only the product rows of the products I have in stock. This is only 150 rows and I would like to just highlight the row in the master worksheet and for that row to be automatically copied to the secondary "in stock" worksheet. Can this be done? I could create an additional column in master worksheet with 0 or 1 switch (0=not stocked, 1 = stocked)
Many thanks for any help. Regards Simon