Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select range of cells and move
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select range of cells and move
In my subject line I said move but I just need to copy and
paste. -----Original Message----- 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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select and move two NON-ADJACENT Excel cells simultaneously ? | Excel Worksheet Functions | |||
Select & Move Range | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Cannot select single cell. Mouse move automatically creates range. | Excel Discussion (Misc queries) | |||
Select and move range throughout workbook | Excel Programming |