Hi all,
I have a database of sales records. Everyday I append records to this database. Each day I have more than 100 records to append and then need to do certain steps on each record (move certain data to populate specific columns and to set the day for each record.)
I've done the below macro, however it runs only on the SAME ROW when recording the macro. So if I've recorded the macro on row 10, the macro runs only on row 10.
Sub FormatRecord()
'
' FormatRecord Macro
' Macro recorded 11-05-2008 by Rayboy
'
' Keyboard Shortcut: Ctrl+k
'
Range("D10").Select
Selection.Insert Shift:=xlToRight
Range("K10:M10").Select
Selection.Insert Shift:=xlToRight
Range("D10").Select
ActiveCell.FormulaR1C1 = "=TEXT(RC[-1],""dddd"")"
Range("K10").Select
ActiveCell.FormulaR1C1 = "=+RC[-2]*RC[-1]"
Range("K11").Select
End Sub
1. How can I run the macro on any row (11, 12 & so on) coz I'm keeping on appending records below.
2. Is there a way to choose all of my records for the day (say 50 records) & tell the macro to run on all 1 by 1. Or do I HAVE TO go to each record & say run on row 11, now on 12 etc.
Any help is much appreciated.
Thanks
Start Free Trial
