gersemale
07-04-2005, 09:19 AM
Hi folks,
I have a simple problem which i am trying to resolve using vba. I have data in the form of:
userA | dataA | dataAA
<null>| dataA1| dataAA1
userB | dataB | dataBB
<null>| dataB1 | dataBB1
I need to pull the information relating to each user only from the cells C2 and C4 respectively.
The easiest way i seen to do this, was copy the data and paste it to a sheet where formulas have been applied to represent the data as
userA | dataA | dataAA
userA | dataA1| dataAA1
userB | dataB | dataBB
userB | dataB1 | dataBB1
using a simple if loop. However this makes the task still difficult. I would prefer to do it all in VBA if possible!
Thanks,
Ger
I have a simple problem which i am trying to resolve using vba. I have data in the form of:
userA | dataA | dataAA
<null>| dataA1| dataAA1
userB | dataB | dataBB
<null>| dataB1 | dataBB1
I need to pull the information relating to each user only from the cells C2 and C4 respectively.
The easiest way i seen to do this, was copy the data and paste it to a sheet where formulas have been applied to represent the data as
userA | dataA | dataAA
userA | dataA1| dataAA1
userB | dataB | dataBB
userB | dataB1 | dataBB1
using a simple if loop. However this makes the task still difficult. I would prefer to do it all in VBA if possible!
Thanks,
Ger