Hi Gurus
1. I have two queries, Q1 has to pass values to the Q2 by using RRI in a workbook. I was able to jump from one workbook to another with the help of VB code but i also need to pass the values for a variable in the receiver query.
2. In my receiver workbook i have one column which has formula, below is the example.
Material group Day of month Plant1 Plant 2 Total Order Acc order (Formula)
Matgroup1 1 2000 3000 5000 Total order + Acc Order = 5000
Matgroup1 2 1000 3000 4000 Total order + Acc Order = 9000
Matgroup1 3 2000 1000 4000 Total order + Acc Order = 13000
.
.
.
.
Matgroup1 30 2000 2000 4000 Total order + Acc Order = 17000
Matgroup1 31 2000 5000 7000 Total order + Acc Order = 24000
The last column has formula and when i Jump from one workbook to another the last column should act dynamically since some months will only have from Day 1 to Day 30 and others will have Day 1 to Day 31 you know how its in Feb.
So the problem is when i jump from one workbook to another query (workbook) some months only has 30 days and hence the 31st day is also calculating by the results. So i need the last column be dynamic. Please let me know ASAP how to solve this problem.
Thanks in advance
Rahul