Macro To Populate Columns

[Bob]

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

 

[kirkm]

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