Combining cells to a separate spreadsheet

**kbss** · 04-26-2008, 05:48 AM

Hi,
I have a database which has cells coloured with different colours for a certain purpose. These cells are widely spread out throughout the database. What I would like to do is find each of the cells with a particular format(i.e. colour and font) and combine these into a separate database - either as a spreadsheet within the same database or as a separate database. I would appreciate any advice on how to go about doing this.

thanks,

kbss

**Leith Ross** · 04-26-2008, 11:50 AM

Hello kbss,

Provided your cell and font colors are not controlled by Data Validation, the code is straight forward, otherwise it will be quite complicated to determine the colors. It would be easier to provide you with the code you need if I could see your workbook. Can you post it for review?

Sincerely,
Leith Ross

**kbss** · 04-27-2008, 07:33 AM

Thanks for the reply. Here is a sample of the database.

kbss

**Leith Ross** · 04-27-2008, 01:50 PM

Hello kbss,

Once the cells are found, how do you want to arrange them on the new sheet? Can you give me an example?

Sincerely,
Leith Ross

**kbss** · 04-27-2008, 03:51 PM

Hi,
I would like to arrange cells in the order they appear on the sheet based on an individual colour. The cells in the first row followed by the second row and then the third row and so on. It would be great if I could get the option to indicate which format cells should be brought on the fresh next sheet on a separate Excel file. I would like only the cells that have the stipulated format on the fresh sheet and nothing else.

kbss

**Leith Ross** · 04-27-2008, 10:24 PM

Hello kbss,

The attached workbook contains a UserForm that will let you choose the worksheet to save the data to, or create a new one, select the font size, and cell background color. All matching cells will be copied over to the selected worksheet starting at the next available row. Let me know what you think. You can run the form by selecting "Run" from the macro dialog box. Press ALT+F8 while in Excel to display it.

Sincerely,
Leith Ross

**kbss** · 04-30-2008, 02:14 PM

Hi,
Thanks for the macro. It was very useful and works well. May I ask how you make this macro? If I add another category with different colour or font, I will have to add the category or create a similar macro. I would appreciate if you let me know how to make this macro. Thanks again.

kbss