Hi Vabz & Nur, I have done some research on both PFA's and Relay code and am a little confused at how they can be used in my project? Could either of you expand on how I could use them or refer me to a tutorial or site that will help me get a better understanding so I can apply it to the project? Thanks again!
On Tuesday, June 25, 2013 2:34:38 AM UTC-4, Ravinder Negi wrote: > PFA.... > > --- On *Mon, 6/24/13, ryan.w...@gmail.com <javascript:> < > ryan.w...@gmail.com <javascript:>>* wrote: > > > From: ryan.w...@gmail.com <javascript:> <ryan.w...@gmail.com <javascript:> > > > Subject: $$Excel-Macros$$ Help in linking data based on PO criteria > To: excel-...@googlegroups.com <javascript:> > Date: Monday, June 24, 2013, 7:41 PM > > 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...@googlegroups.com <javascript:>. > To post to this group, send email to excel-...@googlegroups.com<javascript:> > . > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- 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.
