469,150 Members | 1,955 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

Excel macro to loop and copy selected data

Hi folks,

I'm not even sure if this is the correct place to post, but here goes. I'm new at writing macros in EXCEL VBA and can't figure out how to do the following. I have a book list with various data in various columns. I need to write a macro that will loop through the list (sheet 1) and copy the necessary information to a second sheet using pre-defined data from sheet 1. Any suggestions?

Much appreciated.

ESL teacher
Oct 16 '07 #1
1 1260
Hi folks,

I'm not even sure if this is the correct place to post, but here goes. I'm new at writing macros in EXCEL VBA and can't figure out how to do the following. I have a book list with various data in various columns. I need to write a macro that will loop through the list (sheet 1) and copy the necessary information to a second sheet using pre-defined data from sheet 1. Any suggestions?

Much appreciated.

ESL teacher
Elaborate it more...give example what you want to search and what you want to copy
Oct 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Sylvia | last post: by
1 post views Thread by Steven Stewart | last post: by
5 posts views Thread by Jonny | last post: by
14 posts views Thread by pmud | last post: by
1 post views Thread by Patonar | last post: by
3 posts views Thread by toffee | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.