Remove blank cells before applying Auto-Filter...
Once filter is applied Select the filtered rows shown and paste somewhere
else...


"karishma" wrote:

i have a worksheet in excel and i have used auto filter. i want to have data
for solution acceptance among other mentioned below. i tried
FilterF5Specialvisible cells only copy and paste, but when i tried to
copy it, it selects entire work sheet including blank cells as well and gives
the error message "cannot change part of merged cells" .

for ex. I have the following data in one of the colums in my work sheet and
i want save data for "Solution acceptance" only, please help m with this.
Solution acceptance
Solution acceptance
Solution acceptance
Part availability date
Design release
Part availability
Design release

Design release
Design release
Part availability

Design release
Design release
Part availability date
Final Check
Part availability
Validation
Part availability date
Part availability date
Part availability date
Recommended Solution


thanks in advance