Saved ungrouped cells to a text file
 

I am currently working with a file where I have certain rows grouped. I would
like to be able to save to a text file the cells that are ungrouped. Any help
will be really appreciated? Thanks,

I'd do this:

Create a new workbook
back to the original worksheet
show/hide what you want
select that range to copy
edit|goto|special|visible cells only
edit|copy

To the new worksheet in that new workbook.
select a1
edit|paste

And save that file the way you want.

EMarre wrote:

I am currently working with a file where I have certain rows grouped. I would
like to be able to save to a text file the cells that are ungrouped. Any help
will be really appreciated? Thanks,

--

Dave Peterson

Dave,

Thanks very much for answering my question. Your solution did exactly what I
was looking for.

Thanks again,

"Dave Peterson" wrote:

I'd do this:

Create a new workbook
back to the original worksheet
show/hide what you want
select that range to copy
edit|goto|special|visible cells only
edit|copy

To the new worksheet in that new workbook.
select a1
edit|paste

And save that file the way you want.

EMarre wrote:

I am currently working with a file where I have certain rows grouped. I would
like to be able to save to a text file the cells that are ungrouped. Any help
will be really appreciated? Thanks,

--

Dave Peterson