Copy and Paste range of cells to different tabs according to multiple criteria using VBA

[MineEng]

Hi All,

This is my first post and I'm relatively new to VBA so bear with me here. I'm trying to establish some code to copy data from one tab and paste it to other tabs according to multiple criteria. Here's some more background info:

Data Input:
Cell "A2" contains the Data Date
Cell "C1" contains the Project Name
Cells "B8:B69" contain Equipment Type
Cells "C8:C69" contain Adjusted Equipment Hours
Cells "E8:E69" contain Actual Equipment Hours

This information is then repeated in the adjacent columns with the exception of the referenced Data Date and Equipment Type; these cells remain the same.

The goal is to copy the Adjusted Equipment Hours and Actual Equipment Hours from the Data Input sheet and paste them to the matching equipment type and date found in another sheet of the workbook. The data must be copied to the worksheet/tab matching the project name listed in the Data Input sheet. Additionally, the data will be pasted to the columns on a regular basis matching the listed date in order to develop a historical database. I've copied some of the cells below to see how it looks. I'll try to attach the worksheet. Anything helps.

Cheers


"Data Input" Tab:

Week ending	Project Name	Project 1	Project 2
01-Jan	SPO
	Paid Hours per 24hr period	12
	Days Off	0
Sequencing Period	Weather Delays (days)	0
7	Availability	80%
	Plan vs. Actual	Forecasted Units	Adjusted Equipment Hours	Actual Equipment Hours	Forecasted Units	Adjusted Equipment Hours	Actual Equipment Hours
	Unit 1		0			0
	Unit 2		0			0
	Unit 3		0			0

<tbody>
</tbody>

<tbody>
</tbody>

"Project 1" Tab

Week Ending	1-Jan-14	8-Jan-14
Plan vs. Actual	Adjusted Equipment Hours	Actual Equipment Hours	Variance	Adjusted Equipment Hours	Actual Equipment Hours	Variance
Unit 1
Unit 2
Unit 3

<tbody>
</tbody>