VBA Code that will find, copy and transpose
Solved/Closed
siddharthariver
-
Jan 11, 2010 at 01:24 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 11, 2010 at 09:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 11, 2010 at 09:05 PM
Hello,
I'm looking all around for a VBA code that will:
1 - Search down one column for the word "ADDRESS"
2 - Once "ADDRESS" is found, I need to copy that cell along with the two cells directly above it and transpose these cells' contents to the three columns to the right
3 - I need this action performed down the entire column, which contains about 18,000 instances of "ADDRESS"
I'm looking all around for a VBA code that will:
1 - Search down one column for the word "ADDRESS"
2 - Once "ADDRESS" is found, I need to copy that cell along with the two cells directly above it and transpose these cells' contents to the three columns to the right
3 - I need this action performed down the entire column, which contains about 18,000 instances of "ADDRESS"
Related:
- VBA Code that will find, copy and transpose
- Battery reset code - Guide
- Samsung volume increase code - Guide
- Cs 1.6 code - Guide
- Vba case like - Guide
- Nokia factory reset code forgot - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 11, 2010 at 09:05 PM
Jan 11, 2010 at 09:05 PM
please give one or two examples