Excel Spreadsheet Functions or VBA coding

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay

EXCEL/VBA expert at you service. Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

i can do it for you quickly and exactly

I was just trying with your file and infact I have completed the work. So if you want you can contact me , I will show how to do the dimension from that particular sheet itself. Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards

Hi Im an expert in VBA coding i have been working in sw development for the last 20 years Regards Carlos

Using a simple formula I have been able to put the value of '200' on the door taken from sheet Door A. I presume this is what you require

Hi, I have looked at this for you. Due to the way you are setting the pictures on the Door A, Door B sheet, i don't believe it is possible. You can see the textbox is being transferred to these sheets as part of the image. It is no longer editable, as it is no longer a text box, merely a graphical part of the cell from the Pictures worksheet. the other issue is, i presume you are selecting the door Style on the Data Input sheet before entering any dimensions on the Door sheets, at this point it has already 'captured' the image and transferred it. The only way i could get it to work is to place the text boxes themselves over the ''picture' cells in the Door A, Door B sheets, and link the text boxes directly to the dimension cells on their own sheets. Make sure the text boxes are on top (bring to front), and they will sit on top of the image after you select it from the Data Input Sheet. The issue with this is that you may want textboxes in different locations depending on the style of the doors. I have not thought of a solution for this as yet. Thought i would let you know my findings. Happy to discuss further. But i believe the above to be completely accurate, and don't believe it is possible with your current method of setting the images. Cheers, Caleb.

Hello, I'm an English speaker with a lot of experience coding in VBA. I can get this project done for you but it is slightly complex and I would need some more details. I've looked at your sample file and this is certainly doable. Looking forward to chatting more about it! Cheers, Jay

Understand, how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription.

Hi! I could complete your task in 2-3 days. Feel free to contact me. Hope for cooperation.

Hi, I dont understand good your requirement, but I modified the first Excel. Let me know if is that you need. I cant send you a file here, please open chat and I will send the file to see the modified macro. Best Regards Luis Augusto Guerra

proficient in VBA coding and have more than 4 years of experience with data analysis

Hello, What you have requested is basically done. The request was interesting, I really enjoyed it. :) I can provide you it right now. I tried to do it as flexible as possible, so it means you can add more Door sheets, more door columns on the Data Input sheet, you can add more door pictures. I have entered nice comments for you just in case if later you would like to change the VBA code. The code is transparent and well formatted so hopefully it won't cause you any problem to understand it. Hope to hear about your project soon. Regards, Szilárd

Hello , I’m excited to share with you the proposal for the displaying dimensions on the drawings as per the active sheet values.. I will use excel functions for the solving the problem and use VBA under unavoidable circumstances. Moreover, if you desire I will rearrange information on sheets just to make it more presentable and easy to understand and use. I’m truly excited to be working with you to resolve the dimension issue on drawings. I look forward to your response. All the best Sohail Amin

I have recently implemented similar image handling for one of my client in their dash board. I am sure I can do this as per your need.

Hi, I will do it with macro, then you can access it like an ordinary function. To do this macro needs to identify bitmaps correctly and relate it to an ID. The variables of lenght can be taken from setting for each type of worksheets. regards

HI. I've had a quick look at your file. Why don't you: 1. Remove the textboxes from the Pictures Sheet. 2. Add Textboxes to each of the 'Door' sheets in the appropriate location. And have these textboxes reference cell AM18. Good Luck.

I have created many dashboards in past using excel vba and have hands on experience in vba, would be able to complete the project as per requirement.