Insert row not coping all forumlas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 100 calculated collums on a row. When I insert a new row, about
70 of the formulas automatically copy into the new row. How do i fix it so
all of them copy into the new row?

Thx
 
I had found that already but trying to figure out why some do and some dont.
I also found while doing some sorting that when i sort on collums and tell it
to expand selection that not everying is sorted.

It appears as if somehow excel has decided that each row is chopped into
seperate sections. Need to let it know the entire row is one record.
 

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

Insert rows and copy forumla above it 3
Excel Help to copy information from one row at a time to another sheet 1
Row insertion - lost forumlas 1
Inserting multiple rows 2
make excel copy a row and automatically insert new rows 2
Automatically insert new rows 2
Inserting new rows, which contain the formula in the above the new 5
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top