Forum Discussion
If column 1 in the top table = 'yes' I want to copy column 2 & 3 into the table below columns 1 & 2.
HiMark_Bry
Perhaps this works better. I have inserted another sheet with the report table and a choice cell.
The formula is using the index function and small function to extract the information based on the choice made.
Hope this works better. Do let me know if you need further clarification.
Cheers
Thanks for the helping on this one, although it is still not working. I get a 0 entered in column 1 of the second table. I'm not great on excel yet so your formula went straight over me head (got it sort of). I may not of explained very well. I want a hidden data sheet with lots of rows showing info. When a row is selected by picking yes from the drop down in column 1 then columns 2 & 3 in that row is added to a table on another sheet which is not hidden. We can then pick and chose which bits of info goes in the table which can be viewed to send out. By selecting yes automatically adds the info. The tables I attached was so that I could test in principal then alter the cells/sheet in the formula to suit. I really do appreciate any help on this.
HiMark_Bry
Perhaps this works better. I have inserted another sheet with the report table and a choice cell.
The formula is using the index function and small function to extract the information based on the choice made.
Hope this works better. Do let me know if you need further clarification.
Cheers
That works perfectly! Thanks for your help!
Me again -Sorry! It worked perfectly with 4 column. Now that I have made the sheet to look more like how its going to end up I can't get the formulas to work? In fact some info have been put into the Cells when they shouldn't. I have been trying for the last 3 hours to work out what I have done wrong but must be missing something stupid? Can you have a quick look at the attached and let me know how I have messed it up if possible. Page 4 is sheet in question and the data is on the 'Risk Info' sheet.