Hi All! My name is Ryan. I am pretty experienced in Excel but have run into a dead in with my recent project. I currently manage all PO's for my company to perform financial formulas, analysis,etc. I had been using a basic filter, however we just expanded and now I am dealing with over 50,000 Po's, which obviously takes a huge amount of my time now. My Goal: I currently use an Excel spreadsheet to log all PO's. All information is gathered, entered into a master spreadsheet (with the exception of the PO nuber), and the PO is assigned the corresponding number. What I would like to do is to design a Macro/V-LookUp/Etc that will read the information entered, and copy that information correctly to a seperate spreadsheet based on my specified criteria automatically. I have attached a very basic workbook that might better illustrate my goal. As you can see, all information is entered and saved on the first sheet (Master PO Log). Based on the Dept # (Column D), I would like to design a formula so that all information for the PO entered will also appear on the corresponding tab. I have color coded them for your convenience and to show which information I would need copied, however the actual PO log will rely off of the Dept # only. Basically, any PO I enter into the log will appear in 2 places, the master PO log and the corresponding Dept Tab automatically, with me only entering the infrmation once. My secondary goal would be to have the Dept tab sorted by name, however, since I don't know how many PO's a certain employee will use in the fiscal year, I would like to to expand accordingly. Again, that is a secondary objective and would be more than happy if I could just accomplish the link. Hope that made sense, Thanks for the help!
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Excel Help Template.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
