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 fr
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
> F
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 w
