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.
Hi wumolad, and thank you for replying so quickly! I have attached a second copy of my spreadsheet where I highlighted in the "Main Form" sheet (yellow and blue on page 1 and red on page 2) examples of the data I'm selecting in the first sheet, and the corresponding locations on the second sheet ("Estimate") where I need the cell contents copied for further calculation.
The worker will be using the 'Main Form' to select various items representing specific work activities and their related costs to generate a "scope of work" document. The 'Estimate' sheet will show all items selected from the first sheet, to be added together with tax, thus forming a work/materials estimate document that is given to the client.
Please feel free to ask specific questions -- this tool will serve a small enterprise greatly, more so because there is very strong competition in this field. Thank you again for your time and expertise; I aim to learn much from this experience.
Best regards,
Dan
Hello wumolad, have you had opportunity to look at my request? I need to resolve this soonest. Many thanks again!
- You are kind, Sir! Merci!