Hi,
I hope someone can help as this has baffled me so far for 48 hours
I have a workbook with a few sheets that populate each other, depending on what is entered in the input page.
On this input page I have an itemisation sheet for quoting customers for work carried out. An example of what can be on this sheet is below
Product - QTY- Price - Frequency
Installation - 1 - £30.00 - One Off
Rental pt1 - 1 - £13.99 - Monthly
Rental pt2 - 1 - £15.99 - Monthly
Hardware - 1 - £40.00 - One Off
this data is then passed onto another sheet to create a quotation, with monthly and one off charges seperated by an if statement
=IF(Input!R57="One Off",Input!B57,"")
This will import the one off charges through to a seperate part of the quotation, but obviously leave the monthly charges blank so the quotation would look like
Installation - 1 - £30.00
[BLANK]
[BLANK]
Hardware - 1 - £40.00
What I need is these blank fields removing so it would show the following
Installation - 1 - £30.00
Hardware - 1 - £40.00
Any ideas, but remember it must include the IF statement to enable it to only show the one off charges.
Bookmarks