[RESOLVED] automate the writing of text value into rows and columns that can vary

[scoobster]

Hi

I have a workbook that I create from a macro running in another workbook. The macro copies columns to the new (inactive, I guess) workbook into specific columns. So column "A" from the workbook can go into column "D" on the new workbook. I basically control which column by reading that as a number from a cell.

The problem I have is that I want to fill in a text value in some other columns in the new workbook for each of the rows that are copied. So if I copied 100 rows to the new workbook into column D then I want column A to contain the text value 'Item' in rows 2 through to 102. The column is variable and the number of rows it needs to fill is also variable.

Any idea how I can automate the filling of the text value into rows and columns that can vary?

Many thanks
paul