Check box copy selected data only to worksheet

[Horratio]

Dear all

I am trying to automatically create a quotation document on one worksheet (Quotation) by extracting information entered on a different worksheet (Input Data). I have managed to link most of the data between the two work sheets but I have now hit a wall.

I am using Excel 2010 on Windows 7 Professional. I have created a list of items that I wish to either include or exclude from the quotation (The Input Data Sheet)

I have applied check boxes and managed to get this to work using the following formula =IF('Input Data'!C19=TRUE,'Input Data'!E19)however if a checkbox is left blank I get a “false” statement in the corresponding cell on the “quotation” worksheet.

What I am trying to achieve is only the items selected by checking a box appear on the quotation worksheet in a nice tidy vertical list without any empty cells or false statement between each item. Can this be done with conditional formatting or will I have to go down the VBA route which I am unfamiliar with?

I would very much appreciate if someone could offer any help with this

Thanking you in advance..

 

[igold]

Hi,

I am not really following what you are doing (trying to do), but I can tell you that your IF statement is missing a condition as indicated...

=IF('Input Data'!C19="TRUE",'Input Data'!E19,"WHAT ABOUT FALSE")

igold

 

[Horratio]

Hi

=IF('Input Data'!C19,'Input Data'!E19,'Input Data'!D19) where cell C19=TRUE/FALSE, E19=TEXT, D19=Blank and returns a '0' in the list on the 'Quotation' worksheet, therefore the checkbox functions correctly.

What I am trying to achieve is a continuous list as shown below without gaps or '0's

Exclusions
"% MCD"
Site Fence
Temporary works
Propping of walls and floors
Loadbearing Walls
Forming Openings

What I am getting is the following where '0' is being returned where the checkbox is unchecked (False)

Exclusions
"% MCD"
0
Site Fence
0
0
Temporary works
Propping of walls and floors
Loadbearing Walls
Forming Openings

What function command will achieve the former omitting '0's and closing gaps

Yours Horratio..

 

[igold]

Hi,

I am sorry, I am just not following your example. Perhaps if you showed more of the sheet rather than listing the before and after. I would like to help, but something is escaping me.

igold