This is what I'm trying to accomplish:
On Worksheet "T Label" it looks at columns A2:A100 and also H2:H100. There might be no data between a series of information.
On Worksheet "Database" it puts the information in C2:C
The macro will look for information in Column A on "T Label", and if there is information in Column A (from A2:A), it looks at the corresponding H cell, which will have a number.
From there it'll put the information in C2:C on worksheet "Database", multiplied by the number in Column H on "T Label"
Example:
Worksheet "T Label" has:
A2 - 1234 H2 - 6
A3 - empty
A4 - 9876 H4 - 3
Worksheet "Database" will have the following in Column C:
C2 - 1234
C3 - 1234
C4 - 1234
C5 - 1234
C6 - 1234
C7 - 1234
C8 -
C9 - 9876
C10 - 9876
C11 - 9876
On Worksheet "T Label" it looks at columns A2:A100 and also H2:H100. There might be no data between a series of information.
On Worksheet "Database" it puts the information in C2:C
The macro will look for information in Column A on "T Label", and if there is information in Column A (from A2:A), it looks at the corresponding H cell, which will have a number.
From there it'll put the information in C2:C on worksheet "Database", multiplied by the number in Column H on "T Label"
Example:
Worksheet "T Label" has:
A2 - 1234 H2 - 6
A3 - empty
A4 - 9876 H4 - 3
Worksheet "Database" will have the following in Column C:
C2 - 1234
C3 - 1234
C4 - 1234
C5 - 1234
C6 - 1234
C7 - 1234
C8 -
C9 - 9876
C10 - 9876
C11 - 9876