Forum Discussion
Excel Recording macro
thanks for your prompt response, I have attached the workbook including macro and one shape has assigned to do this task.
to make things easier i have added notes in each sheet
hemnrostam i didn't get a chance to check the macros and see all that going on but based on the format I saw, what if you reverse things a bit and enter the data on the 'main' table and then the 'entry' sheet (which I'm guessing you print or something based on the 'format') uses a lookup. Then you could 'call' up any record by entering that record info in and the rest would get populated.
thanks for the reply, unfortunately, my" output " sheet will be the one to print out based on the master list and items in-depth as it has my company logo and formating.
I am not quite sure if the reverse trick will work here due to the above reason and I am just trying to make the database easier for those using as the just need to fill the data in the Entry form and hit the macro button then all get transferred and sorted. then when they hit another button called "issue "an input box shows up asking them to enter the DN number then all get updated based on that with help of index and match in output sheet.
everything has been sorted except for those two mentioned in the workbook and first msj.
thanks anyway
Hemn
this is to inform you guys that I have figured it out all my issue. and USED offset, match, IF to works with merged cells result from the macro output.
now all is working properly.
thanks
Hemn