I have a spreadsheet that I need to populate 3 columns: Sales, ShipTo/BillTo
and
Product. What I would like to do is to create a macro that will populate
the columns based on the values I specify.

Thanks

--
Bob

On Fri, 6 Feb 2009 20:36:45 -0800, Bob
wrote:

I have a spreadsheet that I need to populate 3 columns: Sales, ShipTo/BillTo
and
Product. What I would like to do is to create a macro that will populate
the columns based on the values I specify.

This populates a cell.

With Worksheets("YourSheetName")
..Cells(row,Column) = Your Data
End With

But how you call that and assign 'Your Data' requires more overview.

Cheers - Kirk