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.