I would like to paste multiple data in a certain column on another sheet

for example on my main sheet i have cells which contain numbers, i would
like to select a week number eg. 430 (dont ask) and then paste all info into
the correct column for the graphs, in this case the 430 column

i think it can be done with combo box to select the week number but then im
stuck.

thanks

ashfire wrote:
I would like to paste multiple data in a certain column on another
sheet

for example on my main sheet i have cells which contain numbers, i
would like to select a week number eg. 430 (dont ask) and then paste
all info into the correct column for the graphs, in this case the 430
column

i think it can be done with combo box to select the week number but
then im stuck.

thanks

How do you know that the 430 column is the 430 column? Is there a header row
with the value 430 in a cell in that row?
If so, you could use the MATCH function to identify the column offset and
then the various paste or assignment operators to populate the column.

Thanks i hadnt considered the Match Function before so ill try that, although
it is new to me.
And yes the column headers of the graph read
.....a..............b.....c......d... etc
1.................429, 430, 431 etc
2.Group 1.....10...
3.Group 2.....20...
4.Group 3.....30...

etc


"Paul Lautman" wrote:

How do you know that the 430 column is the 430 column? Is there a header row
with the value 430 in a cell in that row?
If so, you could use the MATCH function to identify the column offset and
then the various paste or assignment operators to populate the column.

not sure if bumping is allowed so ill also add some info

i have cells that are spread around the "front page" tab, which are inputted
manually, id then like to select the correct week number and have them pasted
into a data tab that i use for charts.

Manually swapping them over is a pain, and ive very limited knowledge of the
Match function,

i tried a few times at work but couldnt get it to work at all

"ashfire" wrote:

not sure if bumping is allowed so ill also add some info

i have cells that are spread around the "front page" tab, which are inputted
manually, id then like to select the correct week number and have them pasted
into a data tab that i use for charts.

Manually swapping them over is a pain, and ive very limited knowledge of the
Match function,

i tried a few times at work but couldnt get it to work at all

coud anyone expand please

"ashfire" wrote:

I would like to paste multiple data in a certain column on another sheet

for example on my main sheet i have cells which contain numbers, i would
like to select a week number eg. 430 (dont ask) and then paste all info into
the correct column for the graphs, in this case the 430 column

i think it can be done with combo box to select the week number but then im
stuck.

thanks