URGENT! Please help! are navigating two columns and transfer results to other sheet
Hi.
On a sheet called 'Extractor data' I have about 30.000 rows with information of registrations inkl. accountname and accounttype.
In column 'accounttype' are 6 different types of accounts fx. project, task, maintenance. In column 'accountname' are the accounts registered into. fx. HRREC, DHD, FTIMPROV. There are about 30 different accountnames. Ie. I have more than 1000 registrations on fx. accountnumber HRREC with the accounttype = project
I want two things:
1. deliver all the different accountnames with accounttype = 'project' in alphabetic order (ie between 0-30 numbers in total)
2. I want these accuntnames to be putted into a sheet called 'Economy' from cell B4 to cell Bx (till they all are there).
After this I want to do the exact same with all accountnames with accounttype = Task or maintenance...
Please help :o)
kind regards
Martin
Last edited by fodaftrykket; 10-06-2011 at 02:30 AM. Reason: Really need help to solve this
Can you explain point 1 again please?
Also, in simpler terms, you want help to filter all data by accounttype and then move it into its respective tab, right?
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks