abhi_jain80
New Member
Hi folks,
I have two worksheets - "Transactions" and "PO" with huge data (more than 100k rows). I need a new sheet to be created on the click of the button.
This new sheet should be similar to the "Output" sheet. It should have unique Item# from the "Transactions" file along with the more columns added. Columns B:G should be picked from "Transactions" sheet and Column H should be picked from the "PO" sheet. The respective formulae's have been mentioned in the "Output" sheet for your reference.
Hope I am clear with the requirement. The sample data along with the output has been attached. I am a newbie in macros, hence reaching out to the experts community. Please support. Thanks is advance...
Regards,
Abhi
I have two worksheets - "Transactions" and "PO" with huge data (more than 100k rows). I need a new sheet to be created on the click of the button.
This new sheet should be similar to the "Output" sheet. It should have unique Item# from the "Transactions" file along with the more columns added. Columns B:G should be picked from "Transactions" sheet and Column H should be picked from the "PO" sheet. The respective formulae's have been mentioned in the "Output" sheet for your reference.
Hope I am clear with the requirement. The sample data along with the output has been attached. I am a newbie in macros, hence reaching out to the experts community. Please support. Thanks is advance...
Regards,
Abhi