I've progressed a little further so I've attached the file I'm working off.
If you use the buttons to get the correct sequence you will see what I am trying to achieve -
1. Click Step 1 - This macro copies all of the "Completed By" names, copies it to the DATA tab, removes the duplicates so...
Hey thanks, that's awesome. I've adapted the code from the first link.
This code works if the spreadsheet tab is already set up for that name/ number reference. I'm now wondering if it is possible for the code to use the Company Name as a reference and create the spreadsheet tabs for each...
Hi. I have a spreadsheet that is generated every fortnight. It lists the details of the completed jobs done by our teams(Person A etc). I need to supply each Person with a summary of their work from this list. At the moment it is all done manually and too many errors are being made.
I would...
Thank you for that solution. It worked on the list I sent but I have loaded in more data and it takes so long to calculate. I need to be able to recalculate a new list every couple of weeks.
Thanks all. I've attached a data sample.
Columns A-H are just information type columns and column H could be used as the 'key'.
The remaining columns hold the quantities relating to the heading (some are blank at this point but may have quantities in the future).
I would like a unique line for...
Hi.
I have a large amount of data listed in rows. Each rows has 93 column headings and there are quantities listed in each column corresponding to the headings. For example:
Type Option1 Option2 Option3
SampleA 1 10 0
SampleB 100 5 3
SampleC 0 20 5
I would like to be able...