athard
03-15-2011, 02:24 PM
Hi,
I have a unique problem that I have solved half way through.
My spreadsheet has 2 tabs. The first tab has some info that changes frequently. The second tab is where the revised info needs to be inserted (not pasted) into row 3 to 22.
So essentially a person goes into tab 1 and enters some info, which is processed through formulas. Then, when they hit a button, the macro will copy cells A10 to A29 and paste special and Insert it into the second tab, starting at A3.
I got it to paste special but not insert, it writes over anything else posted there.
Can somebody help?
Thanks in advance.
I have a unique problem that I have solved half way through.
My spreadsheet has 2 tabs. The first tab has some info that changes frequently. The second tab is where the revised info needs to be inserted (not pasted) into row 3 to 22.
So essentially a person goes into tab 1 and enters some info, which is processed through formulas. Then, when they hit a button, the macro will copy cells A10 to A29 and paste special and Insert it into the second tab, starting at A3.
I got it to paste special but not insert, it writes over anything else posted there.
Can somebody help?
Thanks in advance.