I'm still very new to writing VBA code and appreciate the forum and its
responders that assist in educating newbies like myself. Thank you in advance.

I have data in 2 worksheets ("a" & "b") that I need to copy and paste into a
new row in worksheet "c". The data from worksheet "a" needs to populate
columns (a:af) and the data from worksheet "b" needs to populate columns
(ag:as) in the same row. I've gotten the data to copy properly from worksheet
"a" to worksheet "c" but the data from worksheet "b" is overwriting the data
in worksheet "c" in columns (a:m). I haven't figured out how to find the last
column in the row in order for worksheet "b" data to paste in the correct
location.

--
dhunter43
The Performance Advantage, LLC