insert row below where the cell data is "Wednesday"

  • Thread starter Thread starter gerry.lisa
  • Start date Start date
G

gerry.lisa

Can someone help me? I checked Excel Help and didn't find insert row
based on data....thanks!!

....Lisa Excel 2003
 
look in vba help index for FIND if only one or FINDNEXT if more. Good
example
 
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.
 
Thanks Don.
but this is way over my head...I'm off to find some vba tutorials
online!

....Lisa
 
Thanks Dave.
but this is way over my head...I'm off to find some vba tutorials
online!


....Lisa
 
My suggestion didn't use any VBA. Those are options under the Data dropdown on
the worksheet menu bar.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Formatting Data Tables 1
Insert Cell with IF Formula 0
Inserting a Copied Row inside a table 6
Insert options 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Insert a row without taking formats from above (upper) rows or cells 6
Macro to insert a line when a value changes in a range 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top