I have a workbook similar to the one in attachment, there are many sheets where different users updating information in them.
One sheet will retrieve those information from all other sheets. The user will choose what he want to see by sellecting from the dropdown list.
My Problem.I used this formula for dependent validation list
IF(B4="ROW_Mat",(OFFSET(Row!B1,MATCH(C4,Row!$B:$B,0)-1,1,COUNTIF(Row!$B:$B,C4),1)),IF(B4="Sub-Recipe",(OFFSET(Prep!B1,MATCH(C4,Prep!$B:$B,0)-1,1,COUNTIF(Prep!$B:$B,C4),1)),(OFFSET(Menu!B1,MATCH(C4,Menu!$B:$B,0)-1,1,COUNTIF(Menu!$B:$B,C4),1))))
BUT. if the information are not sorted in the source worksheets. it will not work properly.
I need a solution to make that dependent list works without sorting information in source.
Please check the requirement in the video here
[login to view URL]
Array formulas would solve your problem or some VBA code could do the same. I am an Excel VBA expert and familiar with VBA coding. I could help you with this issue with minimum rate. Hope to hear from you soon!
$15 USD in 1 day
5.0 (8 reviews)
2.6
2.6
24 freelancers are bidding on average $29 USD for this job
Hi there,
Warm Greetings
We came along with your request for Dependent data validation list in Excel and we reviewed your project description. We'd like to help you with confidence and satisfying results.
We have professionals working here with 100% results and more creative and renovative ideas for our clients !
We have worked on several similar projects before!
We are offering our services for more than 5 years in the field of Data Entry, Data Processing, Excel
We have worked on 350+ Projects. Please check the profile reviews
Feel free to message us to discuss briefly about your project !
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days.
Willing to take up your project. Thank you, Regards.
Hi,
I had a thorough look at the formula. Can you please let me know what exactly you want to get done? I think Match () function is creating problem, I would be able to help you once I know what exactly you want to show there.
Regards
Soni
Greetings,
I understand your project description.
I think you want to describe data from putting a formula in your excel spreadsheet.
I am an expert in Excel, VBA, Data processing, and more.
So, I think I can do this task very effectively.
If you hire me Then I trying to complete this task 100% accurate.
So, please discuss more over the chat.
Thank you.
Tanmoy.
I have excellent command on MS Excel and can fix the formula you are facing issues with. I have completed complex projects in Excel before. For instance
- Create a schedule for delivery trucks pick-up and drop for optimal utilization of resources based on various constraints
- Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites.
- Buy and sell bitcoins on Coinfloor and GDAX using respective APIs.
- Built a POS and inventory management system.
- Built a hotel price comparison that pulls data using the website's API.
You can see the reviews of the same in my profile.
Thanks, Archana
I can do that using my expertise in macro.
I've been doing excel enhancement using vba macro for over 7 years now. and I am a subject expert matter and has a strong knowledge with MS excel. Please work with me and i'll make sure that i can do that with high quality result.
Also, currently working with financial reporting using my expertise and certification in Microsoft Excel. I am Knowledgeable with Ms Excel Charts and Formatting.
Communication is not a problem because I know how to communicate both verbally and writing using English language.
I am experienced in the Data entry, Book Writing and Graphic Designer. I also understand your requirement and my aim is to analyze your requirement in logical way and give you perfect solution
Hi there, are you ok with a macro based solution?
I believe your problem reached a complexity that only formulas will not be enough.
I am at your disposal to discuss on chat.
Thanks for the attention.
Hi,
I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports.
I can assure you of high quality and on-time deliverable from my side as that is the sole criteria from my side to work and deliver.
Hope to hear back from you soon :)
#CustomerFirst
Best Regards,
Rohit Ahuja
Email address and contact detail extraction from web- Web data collection- Plain data entry- JPG/PDF to DOC file- Entry in Excel. Data Transcription- Conversion – Processing – Typing – File Conversion
the further details provided by you will decide the first milestone
sir i did projects like this kindly reply i want to discuss it with you
Hello,
Im Reema from Pakistan. I'm highly interested in doing this job for you. I assure you 100% satisfaction and quality work in limited time period. You will be glad to see my amazing work. Hope you will give me a chance to show you my professional skills.
Waiting for your kind response. Thanks
Kind Regards,
Reema
With over 20 years experience in administration, accounting and expertise in office applications, I would love the opportunity to prove this to you on this project.