This is my first post. I am new to excel macros and need some hel
please.

I need to create a macro that I can run every month on that month'
invoices.

I can do all the manipluations I want, apart from one type. I want t
create a column with a formula from row 2 to the last row of data
Because the number of rows varies each month I cannot see how t
achieve this.

Example

Column A = invoice number
Column B = invoice value
Column C = invoice sign (SI or SC)

I want to multiply the invoice value by -1 if the invoice sign is S
for every row that contains an invoice number.

Any help would be appreciated.

Cheers,

Mic

--
Message posted from http://www.ExcelForum.com