I am having
1 Master XL Sheet
4 child XL sheet
Each Sheet Having 2 headers *SerialNumber(Column A) and *Status (Column C)
At a time Need to update the master sheet based on the SerialNumber from 4 child Sheet *Status.
Current Status is :
After the studio Design , if I ran a single single Child Sheet na it’s updating perfectly.
When I am using the whole child Sheet to update in master sheet it’s only printing the SINGLE child Sheet *Status.
What it’s doing na, it’s is removing the *status Of initially ran child Sheet Status…
Design for single Child sheet,
1 Read Range for Master sheet ,
2 Read Range for Child Sheet,
3 For Each Row,
3.1 lookup Function
3.2 write Cell Activity.
Given Condition is
–>> “C”+(DT1.Rows.indexof(row)+2).ToString <<–
Design for Whole Child sheet is Repeating the same design one by one in sequence…
Finally it’s show’s single Child sheet status only…
It’s updating a single Child Sheet only.
Please suggest me what I need to do to resolve this issue…