Hello Everyone,
I'm sure there's a similar thread out there that addresses this issue, but I'm having trouble applying the correct codes to work with my spreadsheet. There are two things I want to do here:
1) Dynamically insert text into next empty row with userform
2) Copy specific cells/range into next empty row if it meets criteria
Issues:
I know this is probably confusing without looking at the file so I'll be more than happy to email it. May someone please help me? I'm having trouble finding forums that apply to my specific situation.
I'm sure there's a similar thread out there that addresses this issue, but I'm having trouble applying the correct codes to work with my spreadsheet. There are two things I want to do here:
1) Dynamically insert text into next empty row with userform
2) Copy specific cells/range into next empty row if it meets criteria
Issues:
- I have a userform which allows you to enter text in specific cells. In this case, it's columns L & M, starting range is L11:M11.
- If there is already data in range L11:M11, I want the userform to populate text in the next empty row below L11:M11 which would be L12:M12 and so on and so forth.
- The data is entered into cells I formatted which looks like a table. The cell ranges that are formatted are E8:Q19. Only range L11:M11 is where text from the userform is entered. I'm not sure how to insert images here so if necessary, I can send the file.
- Before the text in the userform populates the cells, there's a message box that pops up which asks if the data is for a new project. If yes, I want a code that copies the specific formatted cells into the next blank, unformatted row below. If no, I want the userform to enter the text in range L11:M11 or whichever cell below it is empty.
- I don't have codes to execute either action.
I know this is probably confusing without looking at the file so I'll be more than happy to email it. May someone please help me? I'm having trouble finding forums that apply to my specific situation.