Hi.
On a sheet called 'Extractor data' I have about 30.000 rows with information of timeregistration inkl. accountnumber and accounttype. In column 'accounttype' are 6 different types of accounts fx. project, task, maintenance. In column 'accountnumber' are the accounts registered into. fx. HRREC, DHD, FTIMPROV. There are about 30 different accountnumbers. Ie. I have more than 1000 registrations on fx. accountnumber HRREC with the accounttype = project
I want two things:
1. deliver all the different accountnumbers with accounttype = project in alphabetic order (ie between 0-30 numbers in total)
2. I want these accuntnumbers to be putted into a sheet called 'Economy' from cell B4 to Bx until they all are there.
After this I want to do the exact same with all accountnumbers with accounttype = Task or maintenance...
Please help :o)
kind regards
Martin
Bookmarks