SOLVED

Adding cell contents from one sheet to another when selected

%3CLINGO-SUB%20id%3D%22lingo-sub-1462020%22%20slang%3D%22en-US%22%3EAdding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462020%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20containing%20several%20groups%20of%20activities%2Fservices%2Fmaterials%2C%20quantities%20and%20their%20related%20prices.%26nbsp%3B%20Our%20project%20manager%20uses%20it%20to%20select%20work%20requirements%20on%20a%20per%20apartment%20unit%20basis%2C%20and%20the%20sheet%20calculates%20cost%20amounts%20per%20area%20of%20activity%20and%20in%20total.%26nbsp%3B%20Not%20all%20items%20in%20a%20list%20are%20selected%2C%20as%20it%20depends%20on%20needed%20work.%26nbsp%3B%20That%20is%20what%20we%20call%20our%20'work%20scope%20generator'.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I%20need%20is%20to%20transport%20the%20selected%20items%20as%20above%20to%20another%20sheet%20(4%20cells%20containing%20work%2C%20quantity%2C%20price%2Frate%20and%20%24%20amount)%2C%20appending%20items%20to%20a%20new%20list%20that%20will%20show%20those%204%20cells%20in%20a%20column%20which%20is%20then%20totaled%20with%20taxes.%26nbsp%3B%20That%20will%20become%20our%20'work%20estimate%20generator'.%3C%2FP%3E%3CP%3EIs%20this%20possible%20in%20Excel%2C%20and%20if%20so%2C%20how%3F%26nbsp%3B%20My%20experience%20with%20Excel%20is%20moderate%2C%20and%20my%20research%20in%20the%20help%20documents%20hasn't%20borne%20fruit.%26nbsp%3B%20Any%20assist%20will%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1462020%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1462351%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462351%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699009%22%20target%3D%22_blank%22%3E%40DankoSlovak%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20provide%20more%20information%20on%20what%20items%20are%20selected%20and%20where%20do%20you%20want%20the%20selected%20items%20to%20be%20transported%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1464201%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1464201%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%2C%20and%20thank%20you%20for%20replying%20so%20quickly!%26nbsp%3B%20I%20have%20attached%20a%20second%20copy%20of%20my%20spreadsheet%20where%20I%20highlighted%20in%20the%20%22Main%20Form%22%20sheet%20(yellow%20and%20blue%20on%20page%201%20and%20red%20on%20page%202)%20examples%20of%20the%20data%20I'm%20selecting%20in%20the%20first%20sheet%2C%20and%20the%20corresponding%20locations%20on%20the%20second%20sheet%20(%22Estimate%22)%20where%20I%20need%20the%20cell%20contents%20copied%20for%20further%20calculation.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThe%20worker%20will%20be%20using%20the%20'Main%20Form'%20to%20select%20various%20items%20representing%20specific%20work%20activities%20and%20their%20related%20costs%20to%20generate%20a%20%22scope%20of%20work%22%20document.%26nbsp%3B%20The%20'Estimate'%20sheet%20will%20show%20all%20items%20selected%20from%20the%20first%20sheet%2C%20to%20be%20added%20together%20with%20tax%2C%20thus%20forming%20a%20work%2Fmaterials%20estimate%20document%20that%20is%20given%20to%20the%20client.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20feel%20free%20to%20ask%20specific%20questions%20--%20this%20tool%20will%20serve%20a%20small%20enterprise%20greatly%2C%20more%20so%20because%20there%20is%20very%20strong%20competition%20in%20this%20field.%26nbsp%3B%20Thank%20you%20again%20for%20your%20time%20and%20expertise%3B%20I%20aim%20to%20learn%20much%20from%20this%20experience.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3C%2FP%3E%3CP%3EDan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1466866%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1466866%22%20slang%3D%22en-US%22%3EHey%20Bro%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can%20solve%20this%20query%20for%20you.%3CBR%20%2F%3Eyou%20can%20connect%20with%20me%20on%20Whatsapp%20(%2B918484009350)%20or%20Skype%20or%20My%20mail%20Id%20(jdevendra6509%40gmail.com)%3CBR%20%2F%3EOnce%20we%20come%20online%20for%20a%20face%20to%20face%20meeting%20I%20will%20solve%20the%20issue%20for%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469138%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469138%22%20slang%3D%22en-US%22%3EHi%2C%20I'm%20waiting%20on%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E's%20response%2C%20but%20when%20would%20be%20a%20good%20time%3F%20I'm%20at%20GMT%20%2B5%20(Canada%20Eastern%20Daylight%20Time).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469161%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469161%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Can%20you%20please%20come%20online%20by%2015%3A00%20Indian%20Standard%20time%20and%20drop%20me%20a%20message%20on%20%2B918484009350%20WhatsApp%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1477403%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477403%22%20slang%3D%22en-US%22%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%2C%20for%20some%20reason%20my%20reply%20to%20your%20last%20question%20about%20whether%20the%20other%20expert%20had%20helped%20or%20not%20did%20not%20go%20through.%20Here%20it%20is%3A%20no%2C%20there%20hasn't%20been%20any%20assistance%20yet%20due%20to%20a%20time%20zone%20hurdle.%20Thank%20you%20again%20for%20looking%20into%20this%20matter%20for%20me!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1474853%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20cell%20contents%20from%20one%20sheet%20to%20another%20when%20selected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1474853%22%20slang%3D%22en-US%22%3EThat%20may%20be%20a%20challenge.%20Are%20you%20able%20to%20determine%20how%20to%20proceed%20based%20on%20the%20two%20examples%20I%20uploaded%20to%20this%20conversation%3F%20Thank%20you!%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a sheet containing several groups of activities/services/materials, quantities and their related prices.  Our project manager uses it to select work requirements on a per apartment unit basis, and the sheet calculates cost amounts per area of activity and in total.  Not all items in a list are selected, as it depends on needed work.  That is what we call our 'work scope generator'.

What I need is to transport the selected items as above to another sheet (4 cells containing work, quantity, price/rate and $ amount), appending items to a new list that will show those 4 cells in a column which is then totaled with taxes.  That will become our 'work estimate generator'.

Is this possible in Excel, and if so, how?  My experience with Excel is moderate, and my research in the help documents hasn't borne fruit.  Any assist will be greatly appreciated.

9 Replies
Highlighted

Hi @DankoSlovak 

 

Is it possible to provide more information on what items are selected and where do you want the selected items to be transported to?

 

Cheers

Highlighted

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

Highlighted
Hello @wumolad, for some reason my reply to your last question about whether the other expert had helped or not did not go through. Here it is: no, there hasn't been any assistance yet due to a time zone hurdle. Thank you again for looking into this matter for me!
Highlighted

Hello @wumolad, have you had opportunity to look at my request? I need to resolve this soonest.  Many thanks again!

Highlighted

@DankoSlovak 

 

It's part of my to-do list for today. I will revert once I am done.

 

Cheers

Highlighted
You are kind, Sir! Merci!
Highlighted
Best Response confirmed by DankoSlovak (Occasional Contributor)
Solution

@DankoSlovak 

 

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.

Highlighted

@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

Highlighted
@DankoSlovak

So glad the input was very useful.

Regards to everyone and I hope to stop by when I visit Canada.

Cheers