Filling data from one sheet to another (excel)  
Author Message
sarasotamac





PostPosted: Visual Basic for Applications (VBA), Filling data from one sheet to another (excel) Top

Hi,

Maybe someone can help me out with this code. I have one worksheet, that I get everyday that is long and one cell is filled with customer numbers. On another sheet, I have a list of all of the customers and there coresponding customer number. I would like to have a little code that each day I can execute and the daily sheet will populate the customer number cell with the accual customer name.

I don't really know where to start, any help would be appreciated!



Microsoft ISV Community Center Forums1  
 
 
Derek Smyth





PostPosted: Visual Basic for Applications (VBA), Filling data from one sheet to another (excel) Top

Hello,

Have a look at the VLOOKUP and HLOOKUP functions these let you lookup a value based on an unique index (your customer number). How you apply the function really depends on how you want the lookup to work. Have a look and see if you can get them working.