[SOLVED] Autobuild a proposal...

Hi all,

What I am looking to do is build a proposal that pulls data from another worksheet that has product names, quantity and prices. if the quantity is anything but zero/blank, the macro pulls the relevant description, quantity and price and inserts them into the corresponding categories on a predesigned template.

I have the basics down, however, my row spacing seems to be off. I have attached a copy of my spreadsheet so you can get an idea of the layout. Sheet1 and Sheet2 are samples from the sheets I will be using.

PROPOSAL and CALCULATIONS are the sheets where I am trying to get the VBA right, the data inserted into PROPOSALS is right except the spaces between the rows...I can't figure out how to remove those.

Any help is appreciated.

Thanks,
Jim

Build Proposal.xlsm

Increase x only when you copy a row and not for every row tested.

Please Login or Register  to view this content.