Member Avatar for Michael Espinos
Michael Espinos 0 Newbie Poster

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.
tab data is attached.

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
  • 1 Contributor
  • 0 Replies
  • 42 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.