Adding an offset formula to my macro

Hi guys,

I have some data input and ive recorded a macro to merge that info into a nother worksheet.

When i type in different information in i would like to run the same macro but when it merges that information to the other worksheet i would like it to copy to the next available row. Maybe an offset formula?

My macro is as below. Can someone please help me and let me know where i should put the offset formula?

Please Login or Register  to view this content.

ANy help would be great. Thanks!!

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

I'd be happy to look at this issue with you. If you would provide a sample copy of your workbook (with existing macros) that illustrates what you have and what you'd like the results to be, I'm fairly certain we can make it happen.
J