If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Populating a cell based on another (confusing)?

Thread starter afs24
Start date Oct 10, 2002

afs24

Board Regular

Oct 10, 2002

I'm trying to import a number from another program and link it to my spreadsheet. Once I link over the #, I want the number to populate in one cells based on the date in the cell next to it. 1)If I'm pulling data for today I want it to look up all the cells in a range and populate the cell next to the cell with the date (I know it's confusing). If you could give me example code or a formula it would be helpful. 2) Also, I want export a # from antoher program. Once I get that # to my spreadsheet I want that to populate into the next cell of a range of cells as longs as the previous cell has data. Example: if A2 has a # then A3 should populate the # in question? THANK YOU!!