Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi Harry, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
Can you please send me your sample Excel data? You mentioned of an attachment but I cannot find it. You can use the Add Files button to attach your sample Excel file.
Please let me know by replying to me here so that I can help you further.
Thank you for the sample file. Please give me a moment to check it and your requirements.
Are you saying that locations are in F1 to AJ1?
Ok, so you want a summary sheet where you will pick from a dropdown list a particular plant, and then that is the only plant to be displayed in a row?
For instance, you select "Abelia × grandiflora 'Conti' 1G " so it will just show the entire row 2 showing location E3 to have 62 pieces and location E4 with 142 pieces. Is that correct?
Thank you. Please give me a moment to create this kind of summary sheet for you.
Ok, please give me a moment.
I do not understand with "interface". Can you just copy and paste the new data from the new imported file to your template that you sent me?
That is ok. But I need to know if the contents of the IMPORT file is the same in STRUCTURE every time you do an import? That is, if the contents in column A is ALWAYS the same, A2 = Abelia × grandiflora 'Conti' 1G and A683 = Erica x darleyensis 'Mary Helen' 72 CELL. ANd that the only difference are figures but the structure of the table is the same.
My approach is through the use of formulas to build your summary sheet. So as long as the TABLE is there, updated every time you import, your summary works.
But for this to work in the future, you need to create a main template first to include all plants and locations. Otherwise, you need to update the formula in the future.
My approach will not include macros or programming so that you can easily maintain it.
Ok. I am still working on the summary shit and this can take some time. I will just get back to you when I have my first output file ready.
Thank you for patiently waiting. Here is the basic layout of the Summary sheet you wanted:
You just need to select the plant and all information about the selected plant ON the MAIN or IMPORT template will be pulled out and displayed.
I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.