Link to home
Start Free TrialLog in
Avatar of activematx
activematxFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Chris Bottomley
Chris Bottomley
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of activematx

ASKER

This guy is awesome.  Very talented.
Very kind, but i'm just one of many here.

Regards
Chris