Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving only filterd data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving only filterd data
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving only filterd data
thanks for the reply.
i have some blank cells, but they are merged. if possible i can mail you my work sheet and then you can suggest me the solution. thanks for your concern "Sheeloo" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving only filterd data
Yes, pl. do.
Meged cell will give you trouble in Filtering... Pasting etc... add @hotmail.com to to_sheeloo to get my email address... I will work on it tomorrow. "karishma" wrote: thanks for the reply. i have some blank cells, but they are merged. if possible i can mail you my work sheet and then you can suggest me the solution. thanks for your concern "Sheeloo" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving only filterd data
hi
thanks for your help, but what do you mean by "add @hotmail.com to to_sheeloo to get my email address" ? how can i get your e-mail address? thanks "Sheeloo" wrote: Yes, pl. do. Meged cell will give you trouble in Filtering... Pasting etc... add @hotmail.com to to_sheeloo to get my email address... I will work on it tomorrow. "karishma" wrote: thanks for the reply. i have some blank cells, but they are merged. if possible i can mail you my work sheet and then you can suggest me the solution. thanks for your concern "Sheeloo" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving only filterd data
type to_sheeloo then type @hotmail.com
"karishma" wrote: hi thanks for your help, but what do you mean by "add @hotmail.com to to_sheeloo to get my email address" ? how can i get your e-mail address? thanks "Sheeloo" wrote: Yes, pl. do. Meged cell will give you trouble in Filtering... Pasting etc... add @hotmail.com to to_sheeloo to get my email address... I will work on it tomorrow. "karishma" wrote: thanks for the reply. i have some blank cells, but they are merged. if possible i can mail you my work sheet and then you can suggest me the solution. thanks for your concern "Sheeloo" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving only filterd data
thankk you very much. i am sending you my excel file.
thanks "Sheeloo" wrote: type to_sheeloo then type @hotmail.com "karishma" wrote: hi thanks for your help, but what do you mean by "add @hotmail.com to to_sheeloo to get my email address" ? how can i get your e-mail address? thanks "Sheeloo" wrote: Yes, pl. do. Meged cell will give you trouble in Filtering... Pasting etc... add @hotmail.com to to_sheeloo to get my email address... I will work on it tomorrow. "karishma" wrote: thanks for the reply. i have some blank cells, but they are merged. if possible i can mail you my work sheet and then you can suggest me the solution. thanks for your concern "Sheeloo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data | New Users to Excel | |||
Copy Filterd Data from worksheet to another workbook template | Excel Discussion (Misc queries) | |||
Count Text Values in a filterd column | Excel Worksheet Functions | |||
Saving Data | Excel Discussion (Misc queries) | |||
Saving transfered data | Excel Worksheet Functions |