ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   tricky find and replace (https://www.excelbanter.com/excel-programming/423696-tricky-find-replace.html)

Kiba

tricky find and replace
 
Ok I have 400 workbooks where I need to copy information into another cell.
I need it it to search worksheet "Data Entry" for "G. Cut Length" When it
finds that I need it to move down 16 rows. The data in that row needs to be
saved for the find. then I need to move down another 16 rows, the data in
that cell will be what needs to replace the find data. I wand it to search
for the find data on entire workbook and replace it with the other cell. "G.
Cut length is always in column C but the row changes, but the data to find is
alway 16 cells lower, and the to replace the find is always another 16.
Thanks for any help.


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com