Hi All
Have a workbook with 4 sheets
Master sheet
PO sheet
Previously Rcd Reconcilaition sheet
First Time reconcilaition sheet
The master sheet may be up 40000 rows
the po sheet are orders wip
All sheets have common headers but not in same order as master sheet .
My concern am looking for a formula / macro/ or vb for Previously rcd reconcilaition sheet and First time sheets
That is when I put data in PO sheet it has the ability to check data in master sheet in their respective columns required and insert data that has already
been received but the only difference it may be recieved twice or thrice,the N°PO in master sheet will differ ,the index file column header in master sheet is 'ITEMNO which is found in the 4 sheets .
In case the items are first time comers then update the first time reconcilaition sheet as per their headers COLUMN A,B,,D,E,F
In case the items are not first time comers then update the first time reconcilaition sheet as per their headers COLUMN A,B,,D,E,F,G.
Hope someone can help me .
Have a workbook with 4 sheets
Master sheet
PO sheet
Previously Rcd Reconcilaition sheet
First Time reconcilaition sheet
The master sheet may be up 40000 rows
the po sheet are orders wip
All sheets have common headers but not in same order as master sheet .
My concern am looking for a formula / macro/ or vb for Previously rcd reconcilaition sheet and First time sheets
That is when I put data in PO sheet it has the ability to check data in master sheet in their respective columns required and insert data that has already
been received but the only difference it may be recieved twice or thrice,the N°PO in master sheet will differ ,the index file column header in master sheet is 'ITEMNO which is found in the 4 sheets .
In case the items are first time comers then update the first time reconcilaition sheet as per their headers COLUMN A,B,,D,E,F
In case the items are not first time comers then update the first time reconcilaition sheet as per their headers COLUMN A,B,,D,E,F,G.
Hope someone can help me .