Its ugly but Module 2 does work and this is what I was able to muster with my skill. I would like to learn to use variables to rewrite this in an efficient way. I've been trying to use the INDIRECT function to vary the values in the Invoice sheet, cells A19 to A37, as those values are the corresponding worksheet names, didn't get anywhere (don't know if that even works). Thank you very much for your time. Always learning alot here.
Would you manually add the results you expect to see for a couple of MFRs.
Have you considered keeping all your data on single sheet in a single table using exactly the same column layout but with an extra column to identify the MFR.
Having a pukka database simplifies any subsequent analysis you may need.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I don't follow what you meant my "manually add the results you expect to see for a couple of MFRs". Yes, I did consider keeping everything in a same table but that list will be humongous later on. I broke it down by MFR for ease of accessibility. Also, I don't know what a pukka is other than a character figure. Thanks for your quick reply.
I meant on the Invoice sheet pick a couple of MFRs in A19 & A20 then manually add the result you expect to see in B19:F20 after your macro has run.
I don't know what you expect to see since the Update Inventory button doesn't appear to do anything.
Sorry, by 'pukka' I meant proper/real/genuine. It's British slang for an Indian word originating from our colonial days in India.
Keeping data all on one sheet doesn't occupy any more space than spreading it across several sheets. There's no reason given the rich data filtering functionality that would mean data is hard to find, and believe me with such a database analysis is simplified considerably.
Last edited by Richard Buttrey; 11-02-2016 at 08:05 PM.
Richard,
I did consolidate all the pricing info and it did simplify the macro.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks