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.
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.
- DankoSlovak
So glad the input was very useful.
Regards to everyone and I hope to stop by when I visit Canada.
Cheers wumoladI can't thank you enough for your assistance in this project! Thanks to you, I now have a better understanding of the definition and use of Excel objects and how to properly apply them. A small construction company in Canada is very grateful for your assistance.
Best regards,
DankoSlovak