Forum Discussion
Excel Recording macro
I for one is not following what exactly you want. Can you maybe explain it in terms of what columns you have and what you want. For example in the image (it's also easier if you include the workbook instead of just a picture), you have a typical entry table with some number, date and then multiple items that are being added. That is actually a useful format. So you want to "merge" some of this information? what do you mean by that? you can use a master table like this for entry and then a pivot table to summarize the data in different ways (i.e. based on dates, based on product, etc...).
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