Copy, delete, print in one step
 

Hi all,

I have a question, if is this possible:

in worksheet3
copy D27 - D40 in B27 - B40
delete d27 - D40 the cells move left

print worksheet 1 -4x
print worksheet 2 -1x

and all this repeat unti D27 is empty /cca 140x/
Can 15sec. pause between repeat
thnx


--
nordscan
------------------------------------------------------------------------
nordscan's Profile: http://www.excelforum.com/member.php...o&userid=31136
View this thread: http://www.excelforum.com/showthread...hreadid=511006

Copy, delete, print in one step
 

You have a response at your other post in .excel.

nordscan wrote:

Hi all,

I have a question, if is this possible:

in worksheet3
copy D27 - D40 in B27 - B40
delete d27 - D40 the cells move left

print worksheet 1 -4x
print worksheet 2 -1x

and all this repeat unti D27 is empty /cca 140x/
Can 15sec. pause between repeat
thnx

--
nordscan
------------------------------------------------------------------------
nordscan's Profile: http://www.excelforum.com/member.php...o&userid=31136
View this thread: http://www.excelforum.com/showthread...hreadid=511006

--

Dave Peterson