Pull Specific Columns from One Sheet to Another (Dynamically) | Excel VBA Macro

[@jasonjohnston5256]

You completely blew my mind! This is outstanding. Thank you so much!!

[@Jojosmith342]

Perfect. I follo'w your instruction carefully. Trying to type in from screen first & use your written code as refference. You are GENIUS. Thank you so much Greg for all your hard work, time to educate us. Your tutorials are always valuable & absolutely thumbs up both hands 👌👏

[@patriciapetri4792]

I love it!! thank you for teaching us. you made it so simple and easy to understand and follow... great job!!

[@Adam_K_W]

Nicely done. Don't forget to set your objects to nothing before you exit the sub.

[@josephraji296]

Very well explained and it is working very much fine for me after researching so much i found nowhere except yours so i subscribed to your channel.

[@greggowaffles]

I really appreciate that! Thank you for the feedback

[@drewgossage8842]

Really cool, straight to the point, great tutorial!

[@greggowaffles]

Appreciate the feedback 😊

[@richardmoore7955]

@@greggowaffles Dim i As Integer Dim j As Integer Why are these letters used as the integer

[@airman-xx9vg]

finally, got it!!! thanks. code works great 👍👍👍👍

[@greggowaffles]

Glad to hear that!! Thanks for watching!! 💪💪

[@gospelmoto2833]

superb! got a new sub here. Thanks!

[@greggowaffles]

Thank you so much!!

[@arditiljazi6959]

thank you for showing this sample. is there a way of tweaking it to show it can copy and paste the specific columns to another worksheet?

[@jiayilow5657]

Hi, how should i modify it to exclude copying of selected rows (assuming one of the cells in the row-to-be-skipped contains data that i can define as unwanted?)

[@niakubheka9099]

Hi Gregg. Thank you for the vid, it was very helpful. I used the code for my sheets and it worked very well. Can you please assist me with how I can put additional data from a different sheet underneath the already transferred data (on the next empty line) of the worksheet. I need to consolidate from different sheets. Your assistance will be greatly appreciated.

[@cathy___m]

This is insightful. Thank you. But can you please do it with more than 2 sheets? I am struggling with consolidating my 2nd sheet into the master sheet. I managed to do it for the 1st sheet using the method. I know we have to use LastRow to copy into the lastrow of the master sheet but I still can’t seem to get it right.

[@totopanganiban7537]

same here :)

[@andytawandamahdania7943]

It's a great tutorial 👍 But can you tell us how to pull specific column with some applied filter? Thx

[@MohAboAbdo]

Thank you so much

[@greggowaffles]

You are very welcome!

[@ahmetokur8224]

Teşekkür ediyorum.

[@johnnastasi9143]

Excellent, Can this macro be modified to always pull x number of columns and place them in a sheet sequentially Sheet-001, sheet-002, etc?

[@abrahamruiz7034]

Do you happen to have a way to pull columns into different sheets at once?

[@468SQLTrain]

Hi there, how do you deal with copying over a column that contains dates? Thanks

[@Jojosmith342]

Hi Greg, I have a large spreadsheet with >50,000 records. Problem I am facing is there is a heading row (without data) between these records. To consolidate the db I need to remove these heading rows (contain no data, simply heading) on spreadsheets. It is very challenging as it is a huge database. Could you please kindly help to make a tutorial how to resolve this issue? Thanks a lot Greg

[@airman-xx9vg]

don't know what's wrong but I always end up on copying and pasting just the first two columns from raw data on sheet 2 after running the codes, what could be the problem?

[@davidlinton4127]

Could you use an advanced filter instead?

[@h3rw3i]

Hi I got an error on this line " If ws2.Cells(1, i) = ws1.Cells(1, j).Text Then" - Run-time error '1004': Application-defined or object-defined error. How do i fix? Thanks in advance.

[@Andre-ec4xw]

Hi, I was using this code and it worked perfectly, but now I get an error code (400) can you help please

[@vinaypharande2637]

Hi, while running this VBA Macros. I'm receiving fix Run-time error '6' Overflow. How should I fix it. Please guide.

[@zingfam7616]

Hi, I followed your code but somehow the code is only copy and paste one column. Any idea why ? I want to copy only 8 columns.

[@alializadeh8195]

Thanx

[@greggowaffles]

No prob!

[@avinashbiju5329]

What to do if the value to be copied is a number and text, how would that be assigned?

[@Sharath_hp]

One specific column values are not getting copied. What do do?

[@airman-xx9vg]

it would be a big help if you'll share the excel file with that VBA code. 😅😅😅

[@shizmeeamir5307]

Row Count say shows an error " Runtime Error 6 / Overflow " .. What does this mean ??

[@ladyteamer9331]

can this be modified to pull column names that are not an exact match?

[@v12onK]

What if I want to pull a specific date or date range?

[@serginhov2]

Hello, I'm getting error to use this macro, could you please help. Application-defined or object-defined error . I'm trying to put from sheet to another. Not workbook

[@greggowaffles]

What’s your code look like?

[@sarahanyayahan240]

This doesnt work for me. I dont know the prob

[@richardmoore7955]

Dim i As Integer Dim j As Integer Why are these letters used as the integer

[@greggowaffles]

Just a preference. You can use whatever letter/word you want

[@me1234540]

Man you can’t even imagine how I hated this video… sorry but who in the hell that doesn’t have any clue about formulas is going to be able to write all the formulas you wrote? I thought the point of the video was just to apply a direct formula to pull the columns from one WS to another. Not helpful at all! Tutorials are meant to be for people who DO NOT know anything about it.

[@greggowaffles]

Thank you for watching the video and sharing your feedback. I aim to be as descriptive as possible with the video titles so that people know exactly what to expect in the videos. I have beginner tutorials on my channel if you want to check them out, and if there’s a specific example you have I can try to help you out.