Forum Discussion
Solved
If column 1 in the top table = 'yes' I want to copy column 2 & 3 into the table below columns 1 & 2.
I have basic knowledge in Excel. I want to know how to do the following: If cells in column 1 in a table = 'yes' I want to copy that row in column 2 & 3 into a separate table. I have been trying dif...
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
help my access permesion