LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default Copy range from 1 wks to another w/loop

I have a worksheet("S1")with a variable number of rows,
starting at A2. There are 2 parts to moving this data onto
wks ("F1"):

The first part is beginning with wks S1 at cell K2, I have
to copy this date value onto wks F1 starting at cell A2
and then come back to wks S1 and copy Range(A2:J2)to the
same row on wks F1 beginning at B2.

The second part is that I have to come back to wks S1 and
check if there is another date in L2 to send back to wks
F1 cell A3 and again attach the same row range(A2:J2). If
there is no data in L2 I drop down to the next row and do
the above first part again.

note: from K2: and out I may have a variable amounts of
dates that I have to loop thru before I drop to the next
row. The final product on F1 should have all my dates in
column A followed by the range data beginning in Column B.

I did't paste my coding because it is a looping mess for
not using ranges...and it does not work! Can anyone help?

..


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loop through a range Fred[_21_] Excel Programming 6 October 22nd 04 10:45 PM
Need Help With A Loop To Copy vsingler Excel Programming 2 August 17th 04 08:31 PM
copy and paste loop Dillonstar[_5_] Excel Programming 1 December 11th 03 04:22 PM
How? Macro to copy range to new worksheet, name new worksheet, loop Repoman Excel Programming 9 October 9th 03 01:45 PM
search & copy with loop Don Guillett[_4_] Excel Programming 0 July 24th 03 02:55 PM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"