Copy Formula from different cells and Paste in the active columns remaining cells

Hi Friends,

I want to copy the formulas from B1, D1, F1 & H1 and paste in respective column and range equal to column “A”

I have highlighted the cell we need to paste the formula.

PS. For reference I have given the data, actual number of rows & column may vary hence it is fixed between 1 to 22 cells in row.

Hi,

Can you explain me you want same formula on highlighted cell ??

Imran.

[QUOTE=mdimran.ahmed30;4319746]Hi,

Can you explain me you want same formula on highlighted cell ??

Yes, the formula in the 1st cell of the column.
Not that i need to use the same formula for all my requirements.
The request is formula given in the first cell of the multiple column is to pasted in the remaining cell of the column to the range of column A.

[[email protected];4320317]

Originally Posted by mdimran.ahmed30

Hi,

Can you explain me you want same formula on highlighted cell ??

Yes, the formula in the 1st cell of the column.
Not that i need to use the same formula for all my requirements.
The request is formula given in the first cell of the multiple column is to pasted in the remaining cell of the column to the range of column A.

Hi Friends,

Can any one help?

Maybe:

Please Login or Register  to view this content.

Thanks John,

The objective of the requirement is copy multiple cell's formula and past in the same row and the count equivalent to Column "A"
This case B1, D1, F1 & H1 cells to be copied till end of the column which is equivalent to Column "A", the cells given only for example purpose basis time to time ( B1, D1, F1 & H1 ) these source cells may change.
Hence i should be allowed to specify the cells in the Code(Like B1,C1,F1 etc..) to copy till the column end equal to "A".

Thanks John,

The objective of the requirement is copy multiple cell's formula and past in the same row and the count equivalent to Column "A"
This case B1, D1, F1 & H1 cells to be copied till end of the column which is equivalent to Column "A", the cells given only for example purpose basis time to time ( B1, D1, F1 & H1 ) these source cells may change.
Hence i should be allowed to specify the cells in the Code(Like B1,C1,F1 etc..) to copy till the column end equal to "A".

Did you test on your sample? How will the source cells change? How would you identify them if they did.

depending on the requirement formula cell may change , now i am using the below VBA code to copy the formula cell till the column end equal to Column "A".

Since i may have to do this for many column, if you help me to modify the below code to include number of formula cells to copy and past in the same column would solve the requirement

HTML Code: 

.

In the above code is it possible to include more formula cells in a single code like C1,D1, D1,F1...? (destination is equal to Column A)

Does this help?

Please Login or Register  to view this content.

Hi John,

The above code is just coping C1 till end equal to Column A

But i want multiple cells to be copied, as mentioned in the above query how to copy C1,D1, D1,F1...? till end of column ?