Excel Recording macro

Question

Guys&nbsp;Hope all okayi just found it this community from a friend and I am so glad to reach here&nbsp;i have prepared a small database with help of macro recording as you can see in 1,2,3 photos.in items in-depth photo you can see in column C that three times data has been recorded, with different Item rows as it may vary between 1 to 11 items for one single date and DN Number.I have to questions here as I cannot figure out by my self and appreciate if anyone wishes to help&nbsp;1-How can I add something to my code after pasting items to merge cells in column&nbsp; A and B based on column C items ( " meaning merge A2: A4&nbsp; and Merge B2: B4 individually based on rows number in column&nbsp; c while it 3 in this example )2- while I get DN Number and Date from Maste list sheet just by referencing the cell there in&nbsp; a relative shape hoping to copy down the other. but while my items not one all the times this shift to other cells in master list and return the 0 while B5 in master list empty when it needs to get back the B3 in master list sheet instead of B5 due to three-row items.the question here is how we can lock the cell and return cells above in the master list sheet.&nbsp;it might not clear, please see the attached photos.&nbsp;thanks in advance&nbsp;&nbsp;Hemn&nbsp;

mtarler · Answer

I for one is not following what exactly you want.&nbsp; Can you maybe explain it in terms of what columns you have and what you want.&nbsp; 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.&nbsp; That is actually a useful format.&nbsp; So you want to "merge" some of this information? what do you mean by that?&nbsp; 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...). &nbsp;

hemnrostam · Answer

mtarler&nbsp;&nbsp;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

mtarler · Answer

hemnrostam&nbsp; 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.&nbsp; Then you could 'call' up any record by entering that record info in and the rest would get populated.&nbsp;

hemnrostam · Answer

mtarler&nbsp;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&nbsp; "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.&nbsp;thanks anyway&nbsp;&nbsp;Hemn&nbsp;&nbsp;&nbsp;&nbsp;

hemnrostam · Answer

hemnrostam&nbsp;&nbsp;this is to inform you guys that I have figured it out all my issue. and&nbsp; USED offset, match, IF to works with merged cells result from the macro output.&nbsp;now all is working properly.&nbsp;thanks&nbsp;Hemn&nbsp;

Forum Discussion

Excel Recording macro

5 Replies

Resources