Last row copy and paste to different sheet

Hello Everyone!

i'm new to the forum and i'm excited to be here amongst so many savvy excel folks. with that said, I have a task that i'm hoping someone can help me with. i'm trying to run the below code to do THREE things:

1. copy the entire last row of data from one sheet("HL_1")
2. go to or select another sheet("HL_COMBINED") and paste the data on the last empty row. RIGHT NOW THE CODE DOESN'T WORK. IT WILL ONLY PASTE THE FIRST COLUMN ("B") INTO Sheet("HL_COMBINED")
3. as you can see i'm using a button to do this, but I want to do something a little different and frankly i'm not certain it can be done. but I also know excel is very versatile. using Excel 2016, I input my data into the sheet("HL_1) through a "Data Entry Form" which is a Custom New Group I set up in the Data Ribbon. after I select "Close" on the "Data Entry Form" the data automatically populates to the last row. what i'd like to do hopefully is once I hit "Close" on the "Data Entry Form" I want the data to also go to the last row on sheet("HL_COMBINED"). Is this possible? I know it's a tall order, but any assistance is greatly appreciated.

also see cross post: mr.excel.com/forum/excel-question/1065831-copy-paste-problem-4.html. I thought the issue was resolved from a cross post, but then another issue involving error codes came up after we close the post.

Please Login or Register  to view this content.

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Hi RoroBear

Welcome to the forum...Thank you for correcting the problems relating to our rules...
This code will copy the last row from 1 sheet to next empty row of other sheet...

Please Login or Register  to view this content.

3. as you can see i'm using a button to do this, but I want to do something a little different and frankly i'm not certain it can be done.

I am certain that most requirements can be solved...If you are wanting to populate both sheets at next empty rows with code then yes, however, I am not to sure what you mean when saying..."Data Entry Form"

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

Hi sintek,

thank you for the assist and sorry about the rule mishap. as to the code you sent. unfortunately, it didn't work. perhaps I wasn't clear in my original post, it was rather lengthy and ambiguous sorrry. let start with one problem at a time:

1. I have two sheets ("HL_1") and ("HL_COMBINED"). both sheets are identical, both are tables with headers that start in column B and go to column P
2. I want to copy the entire last row of data from sheet one called ("HL_1")
3. go to or select the second sheet called ("HL_COMBINED") and paste the data on the last empty row.

hopefully this makes a little more sense. also, I thought the issue was resolved from a cross post, but then another issue involving error codes came up after we close the post. again, my apologies i'm unable to copy or type in the link as I don't have enough post yet.

Please address post #4. Until you do, there will be no further help. You should not ignore moderation requests.

Can only assist with ListObject code once you have complied to AliGW's request...

Edit...

also see cross post: mr.excel.com/forum/excel-question/1065831-copy-paste-problem-4.html

Please Login or Register  to view this content.

Yes I see...Post 8 should solve...

Coolio...Glad I could help...Pls remember to mark thread as solved...Thanks for rep +

Click star left of post Add reputation...
Top of thread...Thread Tools...Mark as solved...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.