G
gerry.lisa
Can someone help me? I checked Excel Help and didn't find insert row
based on data....thanks!!
....Lisa Excel 2003
based on data....thanks!!
....Lisa Excel 2003
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
look in vba help index for FIND if only one or FINDNEXT if more. Good
example
example
D
Dave Peterson
If you're trying to insert a new row when the values in a column change, maybe
you could select your whole range and do
data|subtotals
You'll be able to add counts and sums and averages....
You may want to sort your data before you do the data|subtotals, though.
you could select your whole range and do
data|subtotals
You'll be able to add counts and sums and averages....
You may want to sort your data before you do the data|subtotals, though.
G
gerry.lisa
Thanks Don.
but this is way over my head...I'm off to find some vba tutorials
online!
....Lisa
but this is way over my head...I'm off to find some vba tutorials
online!
....Lisa
G
gerry.lisa
Thanks Dave.
but this is way over my head...I'm off to find some vba tutorials
online!
....Lisa
but this is way over my head...I'm off to find some vba tutorials
online!
....Lisa
D
Dave Peterson
My suggestion didn't use any VBA. Those are options under the Data dropdown on
the worksheet menu bar.
the worksheet menu bar.