Macro To Populate Columns

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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.
Click to expand...

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
 
Back
Top