![]() |
Macro for multiple rows
I have a Excel spreadsheet with 10 columns and 900 lines.
I wrote a macro to take information off of line 2 on worksheet #1 and place it in a form on worksheet #2 How do I get the macro to run on different lines say line 4 and then line 498 and then 987. (The macro is written for line #2) The form on sheet #2 is the same. Do I need to write this same macro for each line? Is there a way to run a macro on a highlighted area? Can I put a button at the end of each line? Any help will be appreciated. |
Macro for multiple rows
It would help if you were to post your macro here.
Is there some condition that will cause you to select row 2, then 4, then 498 etc? If you know these rows in advance you could use another sheet to just list the other rows and then loop through each value in that sheet to get the data from the appropriate row(s) of the other sheet. But, without further details it is hard to recommend a particular course of action. Hope this helps. Pete On Dec 11, 4:58*pm, sbaby wrote: I have a Excel spreadsheet with 10 columns and 900 lines. I wrote a macro to take information off of line 2 on worksheet #1 and place it in a form on worksheet #2 How do I get the macro to run on different lines say line 4 and then line 498 and then 987. (The macro is written for line #2) The form on sheet #2 is the same. *Do I need to write this same macro for each line? *Is there a way to run a macro on a highlighted area? * Can I put a button at the end of each line? Any help will be appreciated. |
Macro for multiple rows
Please post your code and perhaps someone could help.
-- If this helps, please remember to click yes. "sbaby" wrote: I have a Excel spreadsheet with 10 columns and 900 lines. I wrote a macro to take information off of line 2 on worksheet #1 and place it in a form on worksheet #2 How do I get the macro to run on different lines say line 4 and then line 498 and then 987. (The macro is written for line #2) The form on sheet #2 is the same. Do I need to write this same macro for each line? Is there a way to run a macro on a highlighted area? Can I put a button at the end of each line? Any help will be appreciated. |
Macro for multiple rows
I am tring to print Id cards For my fire hall I have all the members in an
Excell work sheet, Each line is a different member, I am tring to use this sheet and click on individual rows and it place the proper information from that line in the proper place on the card. So it would need to work for lines 2 through 1000 each line individally . I will ask mom who is helping with this for the Macro she is tring to write and post it here when I can get it. "Pete_UK" wrote: It would help if you were to post your macro here. Is there some condition that will cause you to select row 2, then 4, then 498 etc? If you know these rows in advance you could use another sheet to just list the other rows and then loop through each value in that sheet to get the data from the appropriate row(s) of the other sheet. But, without further details it is hard to recommend a particular course of action. Hope this helps. Pete On Dec 11, 4:58 pm, sbaby wrote: I have a Excel spreadsheet with 10 columns and 900 lines. I wrote a macro to take information off of line 2 on worksheet #1 and place it in a form on worksheet #2 How do I get the macro to run on different lines say line 4 and then line 498 and then 987. (The macro is written for line #2) The form on sheet #2 is the same. Do I need to write this same macro for each line? Is there a way to run a macro on a highlighted area? Can I put a button at the end of each line? Any help will be appreciated. . |
All times are GMT +1. The time now is 11:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com