I am very new to the macro tool within Excel, and have used to the Macro Recorder to copy and past fields from an excel template to a completely different master workbook within excel.

I need some help with the function/code that will automatically populate the next row within the master workbook and not paste over previous work.

Can anyone Help? If so, I will go and grab the work computer and poste the VB Code that the macro recorder shows.

Thanks guys!

7/27/2010 5:38:13 PM

assume we can always help, and always post all the relevant information you have available. It's not chit chat, we actually do read, digest, and offer suggestions to more than the first 2 sentences.

7/27/2010 5:43:55 PM

Quote :

"I will go and grab the work computer and poste the VB Code that the macro recorder shows."

At my job this would shortly be followed by a phone call from information security and a nice security guard with a cardboard box approaching my desk.

7/27/2010 6:00:11 PM

HAHA, good thing I wouldn't be giving you the actual excel file Talage, needless to say you have no clue to what I am talking about seeing as how you think you would actually have access to any information other than worksheet names! Silly me to think that I could actually post a question to TWW and get help...the facts are as stated and if you are able to help then in reality you wouldn't need to see any of the code! With that being said are you implying (wwwebsurfer) that you can help me or are you just making another "TWW" comment!

7/27/2010 7:15:51 PM

What the fuck dude? What you're asking is the most trivial of shit related to excel macros, but we at least need more information about what it is you're trying to do.

What the fuck does this even mean

Quote :

" that will automatically populate the next row within the master workbook and not paste over previous work. "

?

There are a lot of fucking rows in excel. Which one is the "next row"? Is the "next row" always going to be the same row or will it maybe be a different row? What the fuck is the "master workbook?

For fucks sake, Talage just made a light hearted comment and you tried to tear him a new asshole.

7/27/2010 7:19:16 PM

Quote :

"the facts are as stated and if you are able to help then in reality you wouldn't need to see any of the code!"

lolwut

7/27/2010 7:28:21 PM

I guess populating the next row within an excel file would mean that the prior row would already have data in it.

Nevertheless I have found the solution, thank you for your help wolf web, you have once again reminded me why I no longer seek your help!

Sub CopyRows()
FinalRow = Worksheets("sheet1").Range("M65536").End(xlUp).Row
' Find the last row of data
' Loop through each row
For x = 2 To FinalRow
' Decide if to copy based on column M
ThisValue = Range("M" & x).Value
' could be any value
If ThisValue = "yes" Then
Worksheets("sheet1").Range("A" & x & ":L" & x).Copy
NextRow = Worksheets("sheet2").Range("A65536").End(xlUp).Row + 1
Worksheets("sheet2").Range("A" & NextRow).PasteSpecial = xlValues
End If
Next x
End Sub

This is an example of what I needed, and with a simple search string I was able to find multiple examples without the "fuck head" comments!

7/27/2010 7:37:58 PM

So you have a macro that will take you 4 clicks to execute (unless you add a button) to do something that takes two mouse clicks, a ctrl-c and a ctrl-v?

7/27/2010 7:57:18 PM

I just wanted to add that this person strikes me as psycho.

7/27/2010 8:08:21 PM

^wtf? Alias?

7/27/2010 11:46:44 PM

wtf happened in this thread?

i think dannyray needs to lose Tech Talk posting ability

7/28/2010 1:51:30 AM

lol @ this thread.

I was helping someone with excel yesterday and noticed they had about 2,000 rows all bunched up together so it was just one black streak across the workbook. I inquired about this and they told me they did it so they could get the effect of an underline. I didn't have the heart to show them border formatting.

7/28/2010 10:42:30 AM