Hello, I'm new to VBA and am trying to build out an automatic copy paste macro to build out a data set. I was curious if anyone with more experience could help me. I don't know how detailed I need to get but Ill make it as much as possible. The cell that will be copied (B1) changes by the second so each value that is copied will be different. I need it to paste in cell A1 then in 30 seconds copy into A2, B2, C2, so on. After 5 minutes, it needs to shift down to the next row and start over, A3, B3, C3. I have tried but get different error codes with every attempt. Thank you to anyone who looks into it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
auto copy and paste Macro
- Thread starter xlnewb21
- Start date
Similar threads
- Question
- Question
- Solved
