Search results for query: *

I use a computer at work and they have it blocked.

Oh I want to use access, but I can not it is not useable in my domain.

It is a check registry sort of. Data 1 is like this: Date CK# AMOUNT Name DT PD DT IS DT STP DATA2 is like this: DATE CK# AMOUNT NAME ADDRESS On one tab the I want the date issued the other the DT PD and the date STP, but I nees to add the address from data 2 to data_1. But...

I have this VLOOKUP in Row H === =IF(IF(ISERROR(VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE)),"None",VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE))=0,"None",IF(ISERROR(VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE)),"None",VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE))).

It did not work. Any one else with a good way to VLOOKUP with a paste.

Thanks I will try this and see how it runs. I have not figured out the storage thing so I will post a copy of my code so far. tonight.

I have but my problem is I have the VLOOKUP but how do I tell a macro to copy paste if is correct then delete. I have my import completed and I hae the vlookup, but if the check # is used more than once with different amounts or names it only records the first one which may be wrong. And I want...

thanks

What I need is to take the data from Data_1 page and seperate on the first three pages. Date IS shows only the date issued. Date PD only shows those with date paid. And Date STP shows only those from Date stop. Only when that is complete I want to take the data_1 and erase it. Then take...

What I need is to take the data from Data_1 page and seperate on the first three pages. Date IS shows only the date issued. Date PD only shows those with date paid. And Date STP shows only those from Date stop. Only when that is complete I want to take the data_1 and erase it. Then take...