I am having a hard time trying to figure out specifically what you asking help for, but I'll give it a go.
In "Sheet1" cell F4, you enter the Model # ("1098" "1190" "1220"). I'd like this data above to ONLY go to the corresponding worksheet as cell F4 and not ALL model # worksheets. Is there a way that I can do this?
In Module1 you have the following line of code:
It takes the name in F4, which you mention above, and creates a reference to the corresponding worksheet, so you're on the right track. It works but forcing the conversion by concatenating a null string is a little clunky; I suggest this to make it more obvious what's going on:
Anyway, then the code goes ahead and does the copy for every individual sheet:
You can replace the above with this, to perform the copy for just that sheet. Is this what you need?
Also, your code appears to have "macro recorder bloat." The macro recorder records superfluous steps that are not necessary for things to work. In particular, you do not have to actually select a cell to do something to it. And you don't have to select a cell, then operate on the selection--you can just operate directly on the cell. For example the following code from Module1
can be simplified as
In a similar example,
becomes
This fix improves efficiency; efficiency is not often a consideration for many macros, but it also greatly helps readability and maintainability.
You also have several Modules with no code. It would clean things up a bit to remove them.
Hope you find this useful....
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks