| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Incrementing
This macro should help Sub Populate() Sheets("OUT").Select Counter = 0 For N = 1 To Cells(65536, 1).End(xlUp).Row If Cells(N, 1) = "……." Then Counter = Counter + 1 Cells(N, 2) = Sheets("IN").Cells(Counter, 1) End If Next N End Sub I've assumed that the data in the IN sheet is in column A and also for the OUT sheet. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=540019 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| variable height variable width stacked bar charts | Charts and Charting in Excel | |||
| object variable or with block variable not set | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| I Need VBA Assistance for global variable question | Excel Discussion (Misc queries) | |||
Threaded Mode
