trasnferring values of a variable and putting it in another regularly

**Abhie** · 05-19-2013, 02:03 AM

Hello Guys,

Here is my problem -
I extract an excel file with the below mentioned format each time from my system daily. But I have to fill in another excel file with an entirely different format, that basically contains some formulas in order to bring out different parameter values. As I dont know how to use VBA code in macro, hence I am having to manually do the whole copy pasting thing from that new file to my home file everytime.

Iv attached 2 excel files containing - 1. source from system (it is extracted regularly with changing of INT CNT column values with cause codes)
2. Destination for analyzing (the 2 NAPs.. IGW MIR IN & IGW MIR OUT have corresponding cause codes)

source from system.xlsx
destination file for analyzing.xlsx

I want to have the column for IGW MIR IN & IGW MIR OUT auto filled in with corresponding cause code values directly from the "source from system" file which is extracted regularly and INT CNT column is always variable.

I hope I could make you clear.

It would be great if you could assist me with the VBA code for this operation.

**oeldere** · 05-19-2013, 02:53 AM

You used 2 differant data.

I used pivot table to get the result.

See if this is working for you.

1 question, why do you put the result in another workbook, you can also use another worksheet for that (I used another worksheet).

**Abhie** · 05-19-2013, 03:23 AM

thanks for replying..

bro, maybe I dint make it clear.. basically 2 workbooks were there because I want to get info(INT CNT values) from the source file and transfer it directly to the destination file, just like the present format i attached.

example: ADDRESS_INCOMPLETE_28 (cause code) of IGW MIR IN which has 49 one day, maybe different in some other day.
But ADDRESS_INCOMPLETE_28(cause code) value in the destination file will also be changed accordingly. Just forget about the percentage column.

Just route the source file cause code value towards the destination file cause code. Its like I want the excel to identify the value of " DESTINATION_OUT_OF_ORDER_27" from (sheet1,A9,B9) and link it with "Destination out of order (27)" sheet(output,A21,B21) and thus all the cause codes and its corresponding values from respective files.

So that, whenever a new file with exactly the same format as source file is extracted every day [this file cant be changed as its directly imported from the system], it can be linked with the existing destination file, and the values will change accordingly as well.

here is your file, Iv highlighted the example with red fill, white font, check sheet1,output.
source from system abbie (oeldere).xlsx

**Abhie** · 05-19-2013, 03:40 AM

Its lIke I wanna link between 2 texts of 2 workbooks, as they are basically indicating the same thing, But the value next column to the text will change accordingly.