Formula to copy data to another sheet

**bberry** · 01-22-2013, 01:50 PM

I have a worksheet with the following tabs: QUOTE, PO, PARTS, & LABOR

I enter data in the parts and labor tab

When a cell in the Quantity column of the parts tab has a value other than 0, I would like the following cells associated with that row copied to the QUOTE and PO tab to create a QUOTE and PO.

I want to do the same thing with the labor tab

I do not have much experience with formulas other than the basics

Can onyone offer assistance?

Thank you,
Bryan

**FDibbins** · 01-22-2013, 03:31 PM

Hi bberry and welcome to the forum

without seeing what you are working with, its a little hard to suggest anything

but try playing around with something like this. on the Quote tab cell, type in...
=IF(parts!A1=0,"CHECK","")

adjust references as needed

if you still have a problem, perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**bberry** · 01-22-2013, 03:44 PM

I uploaded a copy of the worksheet. I enter quntities on the parts tab of parts I need and I want the worksheet to automatically take the quantity, part #, description and price and populate them on the quote tab and PO tab to generate a quote and a po at the same time.

Thanks for the reply.