Forum Discussion
Adding cell contents from one sheet to another when selected
As discussed, I have updated the workbook [sheet Estimate] so that users can select items based on the classification e.g. Cabinetry or carpentry.
Column D contains the classification and the content was formatted as white font colour so it won't show when printed. Based on classification selected in column D, users then have the ability to choose items under this classification in column E.
Column K contains the unit price of the item selected and this has also been formatted as white font colour.
Based on the qty inputted in column J, the amount is computed in column L as a product of column J & K.
I saved the file as .xlsm as there was a simple code to clear previous selection when user changes the classification choice.
I hope this solves the issue.
Cheers.
Hello wumolad, have you had opportunity to look at my request? I need to resolve this soonest. Many thanks again!