Using an IF statement to produce a report based on a checklist

[WeedMan]

Hi

In the "report" spreadsheet i want to display the relevant information from the "List" spreadsheet, if it is unchecked in the "Checklist" spreadsheet.

The report will detail the missing (unchecked) information that is required to be resubmitted.

Workbook attached.

Thanks in advance to anyone that can be of assistance.

WeedMan.

[Azam Ali]

See the attatch file

[WeedMan]

G'day mate

Thanks for your help.

That formula seems to be working fine, thing is, i need all of the information under each relevant heading in the "list" spreadsheet to be displayed in the "report" spreadsheet.

If need be, i can merge all of the info for each heading in the "List" spreadsheet, into one cell per heading.

Thanks again

Weedman

[Azam Ali]

there is no need to merge the cells

use follwoing formula in cell # A4
=INDEX(Checklist!A$3:A$10,SMALL(IF(Checklist!$B$3:$B$10=FALSE,ROW(Checklist!$B$3:$B$10)),ROWS(A$4:A4))-2)
and confirm through Ctrl+Shift+Enter

then copy it on the required range in column C and subsequent colmuns

[WeedMan]

Hello again Azam

Thanks for your help.

That formula is not working. the value in the report sheet does not disappear when the box is checked.

Also, it can not be copied down or across.

Have a go in the attached sheet and see if you can get it to work, perhaps i am doing something wrong

Thanks again for your help

[Azam Ali]

see the attatch file

[WeedMan]

Hey mate, thanks for having a go, but that's not it at all.

The information to be displayed in the "report" sheet, needs to come from the "List" sheet.

The information displayed in the "report" sheet needs to be all if the information under the corresponding heading from the "list" sheet.

[WeedMan]

The attached is close to what i want but it still has some bugs.

Is it possible to amend the formula in the Report sheet so that it produces no gaps or zero's between bunches of information displayed in the Report spreadsheet?

[Azam Ali]

attach file may help

[WeedMan]

Hello again Azam

Mate looks like you've done it.

Note: copy down the cells range highlighted with green

Not sure what this note means though?

[Azam Ali]

there is a formual in Cell A3 which is copy down on column A
there is a formula in cell B4 which is copy down on column B
there is seperate formula in Cell C3, C4 & C5 and Cell C3:C5 are copied down on column C and also copied on column D.

[WeedMan]

For the purpose of adding on to the bottom of the checklist?

Because i am having trouble getting the report to work after adding to the "Checklist", and the "List"!

[WeedMan]

I have attached the final draft of this worksheet.

After updating the information in the list and checklist sheets, the report sheet has stoped working.

If you could please have one more look at this for me, i will be forever in your debit.

Thanks again for all of your help,

WeedMan.

[Azam Ali]

see the attatch file

It is recommended to always use evaluate formula option in the formula tab in order to understand the formula so that you make such formulas by yourself

[WeedMan]

Thanks Azam

Mate there is no way i can begin to understand the bunch of numbers and symbols in your formula's. there is a reason i am posting in the new user forum.

The only problem i am now having is text wrapping.

Each time the report changes, i need the cells to adjust to fit the text. I have selected wrap text, but I can't expect the people that will be using this to have to highlight and wrap the text each time they use the checklist.

[WeedMan]

Azam, just realised i uploaded the wrong file before, could you please have one more look at this for me?

I only had about half of the information on that last one, and once again after i added more info, the report stopped working!

I've looked up the formula evaluation like you suggested, but just cant get the thing to work.

[Azam Ali]

see the attatch file

[WeedMan]

Thank you very much Azam, I owe you big time!

WeedMan