I'm trying to create a macro process to automate a process that uses a "Cell Find" formula. I need to use a looping process to make the solution capable of handling various area with a different number of production lines.
Attached is a simple spreadsheet with an example of the process. Cell A1 will contain the number of iterations for the loop Cell A4 to End of data sets, will contain the production line names associated with the number in cell AI Cell A16 to End of data set will contain the raw data for the process, Using the formula shown in A9 to A12: I want to know if it is possible to make "line 1 Dummy" a variable, so the loop will first use the name from A4 in the formula in A10, insert 25 rows, then use the name in A4 to find the next data set and insert another 25 rows. Continuing this process until all line numbers have been defined with 25 empty rows inserted between each set of data. I have developed the process for inserting the rows, but I need your help to understand how to make the "cells.Find(What:="Variable". I have included in row 25 the full macro currently developed. Any help or suggestions you can offer, will be greatly appreciated. If I need to clarify any of the above, please let me know if I have not provided clarity to the request. I'm new at this, so I'm not familiar with the correct terminology. Regards Dave -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
<<inline: image001.gif>>
SWOOP Example.xlsx
Description: SWOOP Example.xlsx
