Hi, I have uploaded the file AGING_RPT.XLS which also has a notes sheet with information that hopefully will make it clearer in what are the requirements.
Again, thanks for any help that you can provide. Good day, Wilfredo On Apr 26, 12:42 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi Wilfred, > > You have 2 'spreadsheets'. Is that worksheets or workbooks? > > Please attach workbook/s with sample data. > > Regards - Dave. > > > > > Date: Sun, 25 Apr 2010 18:17:54 -0700 > > Subject: $$Excel-Macros$$ Help on consolidating inventory data from two > > spreadsheets > > From: wilfredoriverarol...@gmail.com > > To: excel-macros@googlegroups.com > > > Hi: > > > I need help on a macro that will loop thru a column in a spreadsheet > > with inventory data, compare each lot number on this column with the > > lot numbers in the other spreadsheet until a match is found. Once a > > match is found it will replace 3 parameters (2 dates and a status) on > > the first sheet with the correct data on the same row where the match > > lot was found. A match will always take place since the first sheet > > contains available inventory and the second contains all lots > > information(shipped and available). > > > I have tried many things and will continue to do so until I get this > > done. I bought a book to learn about VBA, because it seems the best > > way to take care of this but I continue the get stuck on things that > > based on what I learned so far do not make sense to get stuck. > > > Your help and or advice will be greatly appreciated, > > > thanks > > > Wilfredo > > > -- > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,800 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know > > they can subscribe to group > > athttp://groups.google.com/group/excel-macros/subscribe > > _________________________________________________________________ > Browse profiles for FREE! Meet local singles > online.http://clk.atdmt.com/NMN/go/150855801/direct/01/ > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
