Reference File: Add Column C -Short Description
To Master File Sheets- Pull Short Description(From Reference) and put in Column C (Match to ASIN) on Master Generated Sheets
On Master Change Column order:
PO (A)
Model Number (B)
ASIN (C)
Long Description (D)
Quantity (E)
No Column changes on Master Generated Sheets. Leave as is Model Number (A) - Quantity (B) - Decsription (C) - ASIN (D)
When Generate Result is run on Master:
If duplicate ASINs then add the quantity together and put the result on the sheets
Example: On Master Item# 1230 36 Evergreen Trees / Picks, 2-Inch, Green, Set of 12 B00KD4KUJY
On Master Item #1230 36 Evergreen Trees / Picks, 2-Inch, Green, Set of 12 B00KD4KUJY
Then on Dave Sheet Item #1230 72 Evergreen Trees / Picks, 2-Inch, Green, Set of 12 B00KD4KUJY
Next: Beth will have two sheets generated - Beth Large & Beth Small
(See Row 2 Col F) If PO is equal to X then those ASINs assigned to Beth on Reference go to sheet Beth Large
All other ASINs assigned to Beth go tp sheet Beth Small
Last: Add on Master new Button on Top "Clear Sheet" which clears the master sheet
Hi,
I have more than 14 years of Excel/VBA exp and I am expert in this kind of work.
I have completed more than 290 projects.
Please look at the feedback left by my employers to know more about my work. Waiting for your positive response.
Thanks.
Hello I am Harry...
After reviewing your project,
I’d love to discuss in more detail with you to provide an accurate
quote and ultimately understand your needs more.
i have 5 year of professional experience in software web application development ..
we believe in work quality ,customer satisfaction and timely delivery projects for better and long time relationship with customer ...
we have 100% satisfaction record for our client, not a single complaint...
We are at present partnering with over 40 firms from UK, US, Austalia,NZ and Canada.