Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Copying and pasting to Sheets...
I have fixed this code. Thank you for your time any ways. I do however have a new query... numerous times i find myself having to type arm lengths of code whe copying and pasting... if cell A1 contains data then copy it to Sheet1 cell A1, if cell a2 contains data then copy it to sheet1 cell A1 BUT ONLY IF a is empty... And so on... so you aquire a list rather than gaps. -- aking198 ----------------------------------------------------------------------- aking1987's Profile: http://www.excelforum.com/member.php...fo&userid=1539 View this thread: http://www.excelforum.com/showthread.php?threadid=31479 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Copying and pasting to Sheets...
Please post the fixed code, beacause i whant to se the correct code. Best regards: willie aking1987 Wrote: I have fixed this code. Thank you for your time any ways. I do however have a new query... numerous times i find myself having to type arm lengths of code whe copying and pasting... if cell A1 contains data then copy it to Sheet1 cell A1, if cell a2 contains data then copy it to sheet1 cell A1 BUT ONLY IF a is empty... And so on... so you aquire a list rather than gaps. -- willie3 ----------------------------------------------------------------------- willie30's Profile: http://www.excelforum.com/member.php...fo&userid=1671 View this thread: http://www.excelforum.com/showthread.php?threadid=31479 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying and Pasting | Excel Discussion (Misc queries) | |||
Copying and pasting ??? | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
HELP: Copying and pasting to Sheets... | Excel Programming | |||
Problem copying range and pasting to multiple sheets | Excel Programming |