allocating specific range of data to each value in a cell.

[kshitij_dch]

I am working on a sheet where i have 500 A1 to A500 Id's .

I have a range of data from F1 to F300.

Manually allocating the data to each cell in A column is time consuming .

is it possible to create a macro that will allocate range of data against each cell in column A .

For Example

A1 - 123 Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
A2 - 345 Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
A3 - 678 Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300

 

[kshitij_dch]

need to allocate specific range to each cell.

 

[My Aswer Is This]

I looked at this yesterday. But to begin with I do not know what:

Manually allocating​

means.

Please define allocated.

 

[My Aswer Is This]

And why are you repeating yourself like this:

A3 - 678 Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300
Allocated data F1 to F300​

 

[kshitij_dch]

Manually allocating means that i have a sheet in which column A has names , column A is dynamic , can be A1 to A5 and can be A1 to A100. Sheet come to us daily.

In that sheet column F has specific range of data. It can be F1 to F50 or can be F1 to F100 etc.

looking at the range in column F , we need to distribute the range or allocate the data to each cell in column A

suppose column F has Range F1 to F30 , I need to copy that range and paste it against A1, again paste this range to A2 , paste range to A3 and so on .......

 

[My Aswer Is This]

So you want to copy Range("F1:F300") to Range("A1:A300") for example. Is that correct?
Or:

Range("F1:F30") to Range ("A1:A30") for example.

Do you want all the data that was previously in Column A cleared out? Or are we adding this new data to column A?

 

[kshitij_dch]

No , i need to copy range F1:F30 to A1 , then same range F1:F30 to A2 and so on , Each Cell has unique name in Column A. for each unique name F1:F30 should be allocated .

Need to clear out the data in sheet so that i can copy new data in the current sheet.

 

[My Aswer Is This]

So you want to put 30 cells of data into one cell?

 

[kshitij_dch]

That's Correct

 

[My Aswer Is This]

So do you want line breaks between each value.

What your asking for will look like this:
MomDadSallyBillyMarkJohnCarolCarDogCatMice