I am hoping that there is a formula, function or macro that I can put into a new workbook to be able to take data from 4 separate workbooks, as follows.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
I need to be able to take data from two columns in each workbook but only from the last month (and will need to do this each month).
Column F contains a code letter (either R, P, I, RPA, RPB or RPC).
Column N contains a qty (just a standard number)
Column P contains the date (in dd mmm yyyy format)
<o></o>
The workbooks are named Workstation A, Workstation B, Workstation C and Workstation D.
<o></o>
Once I have that data I would like the formula, function or macro to then add all the qty’s from column N but only for each code (from column F). So all the qty’s corresponding to R to be totalled, all the qty’s for P to be totalled etc, etc.
<o></o>
If anyone is able to help I would be very grateful.
<o></o>
Thanks for looking
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:PersonName>Doug</st1:PersonName>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I need to be able to take data from two columns in each workbook but only from the last month (and will need to do this each month).
Column F contains a code letter (either R, P, I, RPA, RPB or RPC).
Column N contains a qty (just a standard number)
Column P contains the date (in dd mmm yyyy format)
<o
></o>The workbooks are named Workstation A, Workstation B, Workstation C and Workstation D.
<o
></o>Once I have that data I would like the formula, function or macro to then add all the qty’s from column N but only for each code (from column F). So all the qty’s corresponding to R to be totalled, all the qty’s for P to be totalled etc, etc.
<o
></o>If anyone is able to help I would be very grateful.
<o
></o>Thanks for looking
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1:PersonName>Doug</st1:PersonName>
