Automatically copy cells to another worksheet
 

Hi :D Please help!
This is what I have got...
I do 'For sale' ads. On each sheet is a different listing, for example, cars
is on one, then the next is bikes, then the next is gneral and so on. Some
sheets have more than one listing group, like white goods and electrical on
the same sheet. When I am finished putting all the ads in, I use the sort
tool to sort them alphabetically.
What I want to do on the first sheet, is have them all merged into one long
list, preferably with no blank lines.
How can I do this? Thx in advance.

Automatically copy cells to another worksheet
 

Tricia,

Select all the filled cells on each sheet, press Ctrl-X to cut them, then go to a blank sheet and
select the first blank cell in column B, and press Ctrl V. Then fill in column A with the general
type - Bikes, Cars, Whatever. Then delete the sheet where you started. Do that for each sheet. At
the end, you will have one list on one sheet: apply data filters, and you can look at any subset of
the ads that you want.

HTH,
Bernie
MS Excel MVP


"Tricia" wrote in message
...
Hi :D Please help!
This is what I have got...
I do 'For sale' ads. On each sheet is a different listing, for example, cars
is on one, then the next is bikes, then the next is gneral and so on. Some
sheets have more than one listing group, like white goods and electrical on
the same sheet. When I am finished putting all the ads in, I use the sort
tool to sort them alphabetically.
What I want to do on the first sheet, is have them all merged into one long
list, preferably with no blank lines.
How can I do this? Thx in advance.