activematx
asked on
Easy Excel Formula - Need to move certain area (4x4) rows to the left. Applescript is okay too.
Hi Excel Experts,
I have attached a document as a example.
I have these invoices that are exported from my software. Depending on how much items we order, will depend how many rows are on the excel document.
I need to move (the highlighted part) to the left. I need to do this, because I plan on using another formula which is going to reference the whole column. (and I don't want the subtotal part messing up my other formula). If someone can help me move those columns to the left in a formula or apple script that would solve this issue. Thanks!
P.S. The formula must work for both sheets on the workbook. Since some orders will have one product; while others will have 15 products etc.... Example2.xlsx
I have attached a document as a example.
I have these invoices that are exported from my software. Depending on how much items we order, will depend how many rows are on the excel document.
I need to move (the highlighted part) to the left. I need to do this, because I plan on using another formula which is going to reference the whole column. (and I don't want the subtotal part messing up my other formula). If someone can help me move those columns to the left in a formula or apple script that would solve this issue. Thanks!
P.S. The formula must work for both sheets on the workbook. Since some orders will have one product; while others will have 15 products etc.... Example2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Very kind, but i'm just one of many here.
Regards
Chris
Regards
Chris
ASKER