Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with loop
I've a problem and no clue how to solve this.
I've a table with 3 columns (A:C). Column A is contains a name (sheetname), column B a cell (C20) and column C a value. I want to value of C1, in the cell of B1 on sheet A1 and so on, till the end of the table. I was struggling with the loop (end of table / end of range?). Example of table: ColumnA-ColumnB-ColumnC sheet1-C20-Jan sheet2-B20-Karin sheet1-C21-Doug etc. Thanks for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with loop
Arjan:
try, i = 1 Do While Sheet1.Cells(i, 1) < "" shtname = Sheet1.Cells(i, 1) Worksheets(shtname).Range(Sheet1.Cells(i, 2)) = _ Sheet1.Cells(i, 3) i = i + 1 Loop -- 天行健,君*以自強不息 地勢坤,君*以厚德載物 http://www.vba.com.tw/plog/ "Arjan" wrote: I've a problem and no clue how to solve this. I've a table with 3 columns (A:C). Column A is contains a name (sheetname), column B a cell (C20) and column C a value. I want to value of C1, in the cell of B1 on sheet A1 and so on, till the end of the table. I was struggling with the loop (end of table / end of range?). Example of table: ColumnA-ColumnB-ColumnC sheet1-C20-Jan sheet2-B20-Karin sheet1-C21-Doug etc. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro loop problems | Excel Discussion (Misc queries) | |||
So close! Problems with Loop | Excel Programming | |||
for next loop problems | Excel Programming | |||
Loop code problems | Excel Programming | |||
If... Then Loop problems in Worksheet Event | Excel Programming |