excel automation

[Leo77]

hi I have this requirement

there are two data files one is from last month and another one is the latest months file 

1) I need to do a vlookup November data file with October file on the first column 

2)if the OrderlineNo matches with the previous month data the same data from other columns(Action required, comments)should get in November data (except review new, it should be shown  as review repeat in the new file )

3) if the OrderlineNo doesn't match they should be populated in columns as: "Action required" - yes, "comments" - review - new )

4)for the data which action required is "no" should be color coded to yellow )

this repeats every month 

[Vegar]

I'm not sure that I understand your requirement completely,  but as I understand you want to check whether an id found in the november file exists  in the October file?

You can do this by first loading the October file and then the November file. While loading the November you can use the Exists(OrderLineNo) function to filter out which OrderLineNo that are new to the dataset and which ones that already have been read.

Load *, Exists(OrderLineNo) as NewOrderLine From OctoberFile;

concatenate Load * , Exists(OrderLineNo) as NewOrderLine From NovemberFile;