Ask Mac Questions and Get Answers from Experts ASAP
Would it be possible to send me the file so I can set it up for you on your file
Ok, let me know if you need instructions for uploading files.
A macro is a series of code instructions which can be run by say clicking a button and it will execute the task assigned to it
Got it thanks.
So you want both sheets to be combined into one sheet having both Qty Sold and Qty Available columns. And where columns A and column B are exactly the same (i.e. duplicates) it should appear only once on the final sheet with the quantities combined. Correct
Ok before proceeding with writing the macro I want to make sure that your excel configuration allows you to run macros. If not you will need to change it so macros can run
Here is a test file
When you click the button you should get a pop up box confirming that macros are enabled
Give me 30 min or so and I will have it ready for you...
Yes, but if you are not familiar with transferring macros to other files you can instead simply paste the data from your other files into this 'master' file and run the macro on the new data
Ok, here you go
The macro is triggered by clicking the Go! button on the 'Inventory' sheet. The combined list will be generated on the sheet 'Combined'
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
Yes you are right.
Here is the corrected version
Again please feel free to get back to me if you find that it needs anything else