How to create a conditional macro so it doesn't erase my work?

**Keegan1116** · 02-18-2020, 11:42 AM

Hi there,

I have been creating a worksheet for personal use that will track my project management duties much better than paper can. I have a row of information followed by a huge checklist for each project I am working on. Every time I have a new project, I need to enter all of this data again, so I created a separate sheet that includes a template that I can easily copy and paste under my current project row. My issue is this:

I have tried to create a macro that goes into the template sheet, copies the cells, goes back to the project management sheet and pastes the template under my current work. The problem is that the macros always does exactly as I did, instead of ALWAYS pasting it one row beneath my current project, it will paste it in the exact spot every time, which will erase my data after I've input another row already.

I hope I have explained this well enough. How can I create a conditional macro to always paste the template BELOW my already input work?

**Mumps1** · 02-18-2020, 11:52 AM

It would be easier to help if you could attach a copy of your file. See the yellow banner at the top of this page.

**6StringJazzer** · 02-18-2020, 11:58 AM

The general approach is to use a line of code like this to find out where your existing data ends:

where w is the worksheet where you are pasting (not necessary if the code is in the module for that worksheet).

Please Login or Register  to view this content.

If you provide all your existing code, or better yet, the file (see yellow banner at top of page), we can give a solution specific to your situation.

**Keegan1116** · 02-18-2020, 12:22 PM

I will erase my data and post it here so that you can better understand it. This seems like a solution that will work, though I don't exactly understand the code you have posted. If I record the macros as usual, will I just have to go in and change some of the code or is a completely different process?

**6StringJazzer** · 02-18-2020, 01:33 PM

I am not sure what you are describing in terms of recording the macros--which macros will you be recording? The code I wrote cannot be generated by recording a macro, if that's what you mean.

P.S. You can reply to a post without quoting it. In fact, we prefer it, unless there is something specific in the post you need to refer to.

**Keegan1116** · 02-18-2020, 02:02 PM

Sorry about that. So I have uploaded the file and reposted the question, if you want to take a look at it.

Basically what I did was record a macro going into another worksheet (B), copying a bunch of cells that include a header (with project info) and a checklist beneath it. I then return to the first worksheet (A) and paste those copied cells beneath my current work. I recorded this because I want to be able to just click a button to create a new blank row (with all of the header information and checklist included) rather than having to go into worksheet B and copy&paste them every single time. Hope this helps explain a little better.

**6StringJazzer** · 02-19-2020, 12:18 AM

Originally Posted by Keegan1116

Sorry about that. So I have uploaded the file and reposted the question, if you want to take a look at it.

The file is not posted to this thread and I don't see another thread on this. We would much prefer if you attach your file in this thread rather than starting a new thread with the same question.

If the macro is already recorded, then we just need to adjust the existing macro, using the strategy I described. Also, the macro recorder often results in bloat that can be cleaned up.

As a new member I suggest you take 1 minute to review our rules. There aren't many, and they are all important.

**Keegan1116** · 02-19-2020, 02:52 PM

Here is the link to the post where I posted the file:

https://www.excelforum.com/excel-pro...ml#post5280572

**6StringJazzer** · 02-19-2020, 05:01 PM

Well, this is why I suggested you read the rules.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the other thread

How to create a conditional macro so it doesn't erase my work?

LinkBack

Thread Tools

Display

How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Re: How to create a conditional macro so it doesn't erase my work?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] conditional formatting - doesn't work

Trying to create pivot using Macro - doesn't work?!?

[SOLVED] Macro work in personal workbook, doesn't work in other workbooks

[SOLVED] Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option

Macro that should create csvs of all the sheets of a workbook doesn't work! help!

Excel 2007 : AND doesn't work in Conditional Formatting

[SOLVED] why doesn't my conditional formula work?

Bookmarks

Bookmarks

Posting Permissions