VBA Code that will find, copy and transpose

[Solved/Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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"

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
please give one or two examples