i am looking for an excel expert to fill in a formula to transfer data from the main "all" worksheet to other 3 worksheets.
the rule is to copy across from "all" ONLY the lines that have certain driver letters. ie for all lines that contain d1,d2,d3...d16 are to be transfered across to worksheet "busdriver d" (without any line gaps), i want the formula down to 100 lines
theres is an example on worksheet "example" as to how i want it to look like for the 3 sheets
i have included the file, only need to do for the first 3 worksheets named busdriver d, k and l from the information from worksheet "all"
i will fill the other worksheets myself by following the same rule
this should be a 15-30 min project for someone with advanced excel skills, so please bid accordingly, as i would like to have it asap
a note the worksheet "all" gets the data from another file, hence i need the formulas in the worksheets "busdriver d, k etc"
9 freelancers are bidding on average $26 for this job
i will give u simple automated application , which you can use even in future. Application will take the input files and on clicking button will give u output file in few seconds. Cheers.
We are best when it comes to data entry or Excel [url removed, login to view] know all the rules and formulas of [url removed, login to view] can stand on the client expectation and gives our best when it comes to work and performance