VBA Codes

[Chissa]

Hi there,

I wonder if you can help me, I have a worksheet "Property Listing", which has a list of hundreds of properties on there, and in column A it lists 1,2,3,4 etc to correspond each property.

On a seperate worksheet I want to do a formula to say "Property 1" and then from that I need to pull through other various data.

So in effect on my new worksheet in cell "A4", I want it to write "Property" and then look at the "property listing" worksheet and then list the property number. So I can then add extra code in, then it can move to the next property number?

Really sorry if I am not making myself clear!

Hope someone can help!

Thank you

 

[Andrew Fergus]

Hi

Unless I'm misunderstanding something, you don't need VBA to do this.

Check out Bill's podcast on how to use the VLOOKUP function. I expect that will do what you want.
Learn Excel – “VLookup in Plain English”: Podcast #1533 « Learn Excel from MrExcel

Andrew

 

[Chissa]

Thank you for this.

I do need it through VBA as it is a report that needs to collate all the data in the background, and I also need to incorporate it looking at one row at each time until there is no data left.

Thank you

 

[Andrew Fergus]

Ok. If you could post an example of what your starting data looks like, and what you want to see on the summary/report, then someone should be able to help. At the moment we can't see what the data looks like, so we are guessing as to what is needed.
Andrew