MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating an estimating spreadsheet


Posted by Patrick Carroll on August 21, 2001 11:56 AM

I am trying to create a speadsheet that will allow me to send data from one worksheet to another. The speadsheet is for estimating purposes so I would like the input on one sheet, then have the information roll onto a report style sheet. If there are 100 cells and only 50 have information can I make it so that only the cells with info come over to the other worksheet?
Thank you for any help in advance...


Posted by Tom Urtis on August 21, 2001 8:25 PM

Patrick --

If what you need is simply for cells in a range of 100 cells on the "Report" sheet to display values contained in cells within a 100 cell range on the "Estimate" sheet (or nothing at all), you can enter the following formula (let's say in cell A1 of the "Report" sheet) and copy the formula down and over in that range of 100 cells.

Assuming the ranges are the same (if they're not then adjust), in A1 of Report, enter =IF(Estimate!A1="","",Estimate!A1).

Is there something else you had in mind or does this do the trick?

Tom


I am trying to create a speadsheet that will allow me to send data from one worksheet to another. The speadsheet is for estimating purposes so I would like the input on one sheet, then have the information roll onto a report style sheet. If there are 100 cells and only 50 have information can I make it so that only the cells with info come over to the other worksheet?