B
Big Ben
Hi Everyone,
I have a list of transactions from an inventory report that I impor
into excel and then from there I manipulate the data. I have over 200
transactions per month and am deperately trying to automate.
The spreadsheet appears as follows:
W/O # Type Date Amount
5863 RCVD 02-Jan-04 2.5
5863 VCHR 19-Jan-04 5
5863 RCVD 17-Jan-04 2.5
5867 RCVD 28-Jan-04 5
5867 VCHR 29-Jan-04
I have a list of transactions from an inventory report that I impor
into excel and then from there I manipulate the data. I have over 200
transactions per month and am deperately trying to automate.
The spreadsheet appears as follows:
W/O # Type Date Amount
5863 RCVD 02-Jan-04 2.5
5863 VCHR 19-Jan-04 5
5863 RCVD 17-Jan-04 2.5
5867 RCVD 28-Jan-04 5
5867 VCHR 29-Jan-04