Hi all,
I'm trying to copy information from the main sheet to other sheets as it shown on the attachment.
There are multiple condition it need to be met when it copying into other sheets. I'm not quite sure how to explain it clearly so I made a before and after of what I want to achieve.
Thanks
Hello HXIO:
Based on what I saw, an option is to create a number of VLOOKUP functions on your P(after) tabs, combined with IF statements for each field, and each sheet, with breakouts that will extract your style number from the SKU, pricing, etc. and allow for blanks("').
A messy project.
Pete
@PeteABC123
Thanks for the suggestion, I know it's indeed messy I'm not sure if this would work or not cause I will generate each invoice first before I copy them from the main sheet...
Taking inspiration from Pete's suggestion the following formulas are modeled on the P834...before sheet.
1) For 'Style Number' column:Formula:
Please Login or Register to view this content.
Note that the cells in even numbered rows of the 'Style Number' column are preformatted.
2) For the 'Qty' column:Formula:Please Login or Register to view this content.
3) For the 'Unit Price' column:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
@JeteMc
Thanks for the help! The formulas work like a charm.
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks