Macro recording, selecting rolls based on found data
Posted by Dan on May 01, 2000 10:24 AM
I have many many route sheets to edit. The problem is that the sheets are not standard even though they contain the same information. I want to insert a row below a certain value but that value is present on different rows on different worksheets. It may be on row 26 on one and 28 on the next. I have tried to record a macro that finds that value and then on the next row inserts a line but it assigns that row # to the macro. Example: finds value on row 25, the next line reads something similar to...
Any thoughts? I hope I've made things clear. If not I'll amend additional info.