hi guys, thanks to all those who tried to help last time with the times...everything is working!
here is a new problem but i think it is simple
1. please look at sheet 2 and see that there are raw data in column f corresponding to column a(category name). so right now im just manually copying and pasting column f in sheet 2 back to sheet 1 which is not bad but im wondering if it is possible that excel does the categorizing of column a (sheet 2) and puts the data on sheet 1. i have to do hundreds of sheets so.. the hard part is that it doesnt say category for each row, it just shows blanks until the next category.
2. this is just a nusance, if you notice f20-f41 on sheet to it doesnt say issued,final but instead says translan which causes the extraction columns (sheet 1, column b d f, h) to not work.. right now my solution is notice it manually and find and replace with (issued,final) but i m wondering if it could be written in the extraction columns or something.
Bookmarks