Filtered Rows in Excel 2010 cannot copy formula and then copy records
Posted on 2014-03-24
Excel 2010 64 bit
I have a spreadsheet that has over 32,000 rows.
I have many rows I need to modify.
So I filtered the first 9500 since the filter has a 10,000 record limit.
I have this
A B C D E F
1 98 This is a file name 1 1 M;\path =right(b1, len(b1)-3)
2 50 This is a file name 1 2 M:\path =right(b1, len(b1)-3)
3 66 This is another one 2 1 M:\path =right(b1, len(b1)-3)
F is so I can strip off the numbers in the rows that contain the number.
When I filter column E which contains the filename and path to that file I get the list of all the files in the first 9,500 records
Problem is when I copy down column F formula to all the rows in the filter it places bad information in the rows. looks like from the wrong cells.
I copied all the filtered rows and placed them into a new page ran the formula on all the rows looked good
But when I copied them into the original spreadsheet over top of the filtered rows they all get bad data again.
How can I modify all these records so I do not have to scroll down thru 32000 rows.
Any help would be appreciated.