I am using the MACRO below and it is working but I need to do this for 50 rows and eventually up to 4 or 500. Is there an easier macro to accomplish this without having to reference each row? I am copying the Tracking Number (Column A) in the Data Tab to column B in the Audit Data tab.
Please Login or Register to view this content.
Last edited by Glenn Kennedy; 10-19-2023 at 03:51 AM.
ArtikPlease Login or Register to view this content.
Patchpollito... please remember to use code tags around your code. I've added them in your opening post.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank YOU, Artik! This worked! Question, if I were to apply this to another workbook where there are more or less rows to skip in the "Audit Data" tab would I have to change something in the macro?
Thank you, Glenn! I apologize for my lack of knowledgebut I don't know what code tags are. Appreciate the education
Last edited by patchpollito1; 10-19-2023 at 12:27 PM.
This loop declarationsays that it will start inserting data from row #2, while Step says the number of rows to be skipped in the next rotation of the loop (more precisely, 4 rows will be skipped, and in the fifth one the next value will be inserted).Please Login or Register to view this content.
You can insert code tags in three ways:Originally Posted by patchpollito1
1. before you paste the code, use the [#] icon and then between the [code] tags you get, paste your code.
2. first paste the code, then select it in its entirety and use the [#] icon.
3. you can also type the tags manually. Before you use this method, see how the tags inserted in step 1 or 2 look like.
Artik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks