Macro for repeat functions with if condition

[mkanagaraj]

Hi...

Can anyone help me to prepare a macro for repeat function till the reference column has a data.

To illustrate, if a cell of (column-1 of worksheet-1) has a number, the number needs to be referred in worksheet-2 for analysis and the result shall be copied back in a column-2 assigned in worksheet-1. This function shall be repeated till column-1 has data cells.

I am looking for a macro which can repeat the said function till it finds a data in column-1.

Looking forward for a solution as soon as possible.

Thanks

Kanagaraj

[stojko89]

You have a Loop option or For Each Cell in a range option...
For better understanding of your problem you should upload a sample workbook that contains the current situatius and the outcome. It's much easier to make a code that way

[mkanagaraj]

mkanagaraj.xlsx

As desired, find attached sample file, wherein sheet-1 has reference cells in yellow colour and result cells in green colour.Hope, this would provide much clarity on my query.

Please provide a solution to it.

Thanks

Kanagaraj

[stojko89]

Here you go

[mkanagaraj]

Thanks for your guidance

May you help me to update the macro if i add another criteria, which is marked in blue colour to analyse.

This has 2 criteria as reference, which shall repeat. The file is attached

I tried to revise the macro, but i could not get. mkanagaraj - Calculate (2).xlsm

Please help me.

Thanks

Kanagaraj

[stojko89]

You want the macro to only calculate the results of the cells in column A if they are marked blue? Or what?

[mkanagaraj]

No.

Column A (Blue) and Column B (Yellow) of Sheet1 are to be referred in C2 and C4 of Sheet2 respectively to get the result in C6 and transfer the same to Column C (Green) of Sheet1. The function shall be repeated for all data cells.

Column A and Column B are reference data
and Column C is the result.

Hope, it is clear. Plz revert back in case of further clarification.

Thanks

Kanagaraj

[stojko89]

No I think I got it now.
I'll get back to you on Monday morning

[mkanagaraj]

Hi Stojko

Looking forward for your suggestion.

Thanks

Kanagaraj

[stojko89]

Yes hi. I was wondering. Why do you need the results copyed from one sheet to another and then the result back to sheet 1?
Why can't you just insert the formula in Column C and you'll have the calculated results withouth copying and withouth using a macro...

[mkanagaraj]

You are right. But, I have some similar analysis, which is derived from cluster of formulas with number of other references and therefore, i can't insert formula in column C. The result will be taken from another model all together. Therefore, this macro would help me to use for such analysis.

[stojko89]

So once again
If column A is blue and column B is yellow calculate the result on sheet 2 and copy it in column C and color the result green?

[stojko89]

I've changed your blue color so I don't have to set the shading and so on...
But here you go.