![]() |
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