| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Next Loop...Copying from a cell one column to another...
Hi all. I am brand new to VBA, and am fumbling my way thru this. Any help
is appreciated. I have one worksheet with several thousand rows, and about 10 columns. I need to loop thru all the rows in column 5 to see if each cell meets a certain criteria (is the text there = "Person" or "Place" or "Thing"?) If R2, C5 = "Person", then copy "Person" to R2, C4. If R2, C5 = "Place", then copy whatever is in R2, C6 to R2, C4 If R2, C5 = "Thing", then copy whatever is in R2, C7 to R2, C4 You'd think, with all the Excel help pages and example code out there, that I could figure this out. But apparently, I can't. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a cell down a column | Excel Discussion (Misc queries) | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Loop through column headers to search from column name and get cell range | Excel Programming | |||
| copying the column of the active cell to another column | Excel Programming | |||
| select column cell in same row as loop result? | Excel Programming | |||
Threaded Mode
