Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with double loop
r = 1
Does until cells(r,1) = End Report r = r +1 The performs a control find command which looks for A field called "name" and paste it onto cells(a4) sheet2 A field called "Address 1" and paste it onto cells (b4) sheet2 etc etc The loop then runs again pasting 1 row down see below A field called "name" and paste it onto cells(a5) sheet2 A field called "Address 1" and paste it onto cells (b5) sheet2 Thank you in anticipation Marcus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with double loop
And where might we expect to find "name" and "Address 1"
-- Don Guillett SalesAid Software "Marcu2" wrote in message ... r = 1 Does until cells(r,1) = End Report r = r +1 The performs a control find command which looks for A field called "name" and paste it onto cells(a4) sheet2 A field called "Address 1" and paste it onto cells (b4) sheet2 etc etc The loop then runs again pasting 1 row down see below A field called "name" and paste it onto cells(a5) sheet2 A field called "Address 1" and paste it onto cells (b5) sheet2 Thank you in anticipation Marcus |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with double loop
Sheet 1 we want to use CTRL find to locate the address and name field which
are in a none text to colume field i.e name micky mouse address disney land "Don Guillett" wrote: And where might we expect to find "name" and "Address 1" -- Don Guillett SalesAid Software "Marcu2" wrote in message ... r = 1 Does until cells(r,1) = End Report r = r +1 The performs a control find command which looks for A field called "name" and paste it onto cells(a4) sheet2 A field called "Address 1" and paste it onto cells (b4) sheet2 etc etc The loop then runs again pasting 1 row down see below A field called "name" and paste it onto cells(a5) sheet2 A field called "Address 1" and paste it onto cells (b5) sheet2 Thank you in anticipation Marcus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
Help with "double" loop! | Excel Programming | |||
double loop madness - help with macro | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |