SkoobiDrew
05-02-2014, 02:12 PM
Hello everyone, I'm very new here so please forgive any format mistakes I may have made in my posting. I've looked through the other threads but have not found a direct solution for this situation, hopefully I am not asking something that has previously been answered.
The objective of this is to setup a data file from which I will print labels.
I need to basically copy a range of cells from a row on one tab, then paste (values, number formats) these onto another tab multiple times based on the value of a cell at the end of the range.
Here is an example of what I have, and what I need it to look like after the macro has run:
Here is the data for the macro:
Date
Zone
Project ID
Req_Name
Requestor
SEED1
SEED2
SEED3
SEED4
SEED5
SEED6
Number of Labels
25-Apr-2014
G-05
11224
Germination Study
Sandy
ABCDE
2
25-Apr-2014
G-05
11220
Bioassay
Jeff
EDCBA
1
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
3
25-Apr-2014
E-01
11219
Pollen donors
Jamie
POLKM
TREWQ
2
This is what the result should look like on another tab:
Date
Zone
Project ID
Req_Name
Requestor
SEED1
SEED2
SEED3
SEED4
SEED5
SEED6
25-Apr-2014
G-05
11224
Germination Study
Sandy
ABCDE
25-Apr-2014
G-05
11224
Germination Study
Sandy
ABCDE
25-Apr-2014
G-05
11220
Bioassay
Jeff
EDCBA
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
25-Apr-2014
E-01
11219
Pollen donors
Jamie
POLKM
TREWQ
25-Apr-2014
E-01
11219
Pollen donors
Jamie
POLKM
TREWQ
Thanks, in advance, for any help/advice you can provide!
The objective of this is to setup a data file from which I will print labels.
I need to basically copy a range of cells from a row on one tab, then paste (values, number formats) these onto another tab multiple times based on the value of a cell at the end of the range.
Here is an example of what I have, and what I need it to look like after the macro has run:
Here is the data for the macro:
Date
Zone
Project ID
Req_Name
Requestor
SEED1
SEED2
SEED3
SEED4
SEED5
SEED6
Number of Labels
25-Apr-2014
G-05
11224
Germination Study
Sandy
ABCDE
2
25-Apr-2014
G-05
11220
Bioassay
Jeff
EDCBA
1
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
3
25-Apr-2014
E-01
11219
Pollen donors
Jamie
POLKM
TREWQ
2
This is what the result should look like on another tab:
Date
Zone
Project ID
Req_Name
Requestor
SEED1
SEED2
SEED3
SEED4
SEED5
SEED6
25-Apr-2014
G-05
11224
Germination Study
Sandy
ABCDE
25-Apr-2014
G-05
11224
Germination Study
Sandy
ABCDE
25-Apr-2014
G-05
11220
Bioassay
Jeff
EDCBA
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
25-Apr-2014
G-06
11235
Friday plantings
Heather
FGHJK
DFRGY
SXDCF
REWQA
25-Apr-2014
E-01
11219
Pollen donors
Jamie
POLKM
TREWQ
25-Apr-2014
E-01
11219
Pollen donors
Jamie
POLKM
TREWQ
Thanks, in advance, for any help/advice you can provide!