I'm new to all this and trying to learn as I go along. One task I'm trying to do is to write some VB code that updates portions of one tab of an excel file from another tab in the same file. I want this to work on an ongoing basis so that the data can be refreshed everytime that new data is available.
The tab that the updated info is coming from looks like this and only the rows labeled 'b' and columns labeled 'Actual' need to be used
Apr-06 Apr-06 May-06 May-06 Jun-06 Jun-06
Budget Actual Budget Actual Budget Actual
abc a 1,800 1,200 1,800 1,300 1,800 1,300
b $737 $915 $771 $1,366 $771 $1,366
c $1.3 $1.1 $1.4 $1.8 $1.4 $1.8
def a 0 1,600 0 1,400 0 1,400
b $0 $0 $0 $0 $0 $0
c $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
ghi a 4,300 1,400 6,700 1,600 6,700 1,600
b $210 $1,818 $140 $617 $140 $617
c $0.9 $2.5 $0.9 $1.0 $0.9 $1.0
jkl a 700 1,200 750 1,400 750 1,400
b $0 $0 $0 $10 $0 $10
c $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
mno a 300 1,065 325 1,082 325 970
b $506 $251 $525 $246 $525 $274
c $0.2 $0.3 $0.2 $0.3 $0.2 $0.3
The tab that needs to be updated looks something like this, with the line b actuals from above replacing fy2006 values for the 3 months:
abc
Apr May Jun
FY2006 0 1,372 1,147
FY2007 0 0 0
def
Apr May Jun
FY2006 0 1,372 1,147
FY2007 0 0 0
ghi
Apr May Jun
FY2006 0 1,372 1,147
FY2007 0 0 0
jkl
Apr May Jun
FY2006 0 1,372 1,147
FY2007 0 0 0