Quote:
Originally Posted by mars1886
This copy paste thing isn't a one time deal either, the WHOLE macro is.
|
In that case, my previous comments may still apply and, given your confessed lack of vba experience, that seems even more likely. All the same, though, without knowing the scope of the project it's impossible to say for sure.
Quote:
|
Also, there are 7+ tabs that will be copied from and at least 1 copy/paste per tab. So if you could, could you give me the syntax by chance? To be even more clear, I need it to paste to a specific row of my choosing, and that row will increment by one after each paste, if that makes sense.
|
There really isn't anything generic about the code to do this. I could post some arbitrary code copy for copying & pasting to an active cell, but I doubt that would get you much farther. You would need to provide a whole lot more detail, especially: how the code is to identify the sources to be copied in each case (e.g. you say you have 7+ tabs, so how does the code identify which tabs to copy from and where to find the data on those tabs); the order in which the copy/paste for the different sources to occur; whether the source format is to be retained; whether there are formulae in the sources that are to be retained, or just values; etc.