Requesting a Macro to be written

**Robert1955** · 05-13-2012, 07:32 AM

I have formulas in cells B2:G2. I have a MATCH function in cell L3 giving the number of rows containing data in another worksheet within the same workbook.

Either using L3 or having the MATCH function in a macro (this I prefer) I need help with a loop macro where the loop continues to run until reached the row described in the MATCH function. The number of rows containing data will vary and so a fixed number is not viable, I need the macro to identify when the loop ends independent from other runs.

Can any body help.

Robert

**npamcpp** · 05-13-2012, 07:44 AM

Hi,

please upload a workbook with your data structure. It is not clear from your descriptions what you want to achieve. For example, the Match function in L3, what exactly is it?

**Robert1955** · 05-13-2012, 08:08 AM

This is the formulae in L3 =MATCH(9.999999E+306,'Data Entry'!B:B). Column B:B in the worksheet "Data Entry" has data in 1334 rows. L3 in the worksheet "DATA CONVERTER" both in the same workbook have the result of 1334. I have formulaes in the cells B2:G2 in the worksheet "DATA CONVERTER". I want the formulaes in the 2nd row (B2:G2) to be copied and pasted to the last row, in this example row 1334. This row is not fixed as the data in Column B:B in the worksheet "Data Entry" is not always the same. I do not know how to upload a document on this site as this is only my 2nd visit.

Robert

**npamcpp** · 05-13-2012, 08:19 AM

After you have changed your thread title as requested by the moderator, please upload a workbook that shows your data structure. It will be impossible to guess what data you have in your spreadsheet and how to amend your formula to work.