Excel 2007 : Copy cell to another worksheet if cell starts with a specific string

Could you please help?

I have a worksheet with a lot off different information on it. All the data in the columns are not always of the same type. example: column B contains most of the time text, but sometimes starts with a specific string "tc-"

I would like to copy the cell if the cell starts with this specific string. Is this possible?

Do u want to copy just that cell or the whole row with that data with specific text?

that's what I also found, but I don't want a new row to be displayed if there is no "tc-". I guess this is only possible with a macro???

Originally Posted by jraj1106

Do u want to copy just that cell or the whole row with that data with specific text?

I only need that cell

Hi

Try this:

copycell.xlsm

Originally Posted by Fotis1991

Formula says: If you don't find this "tc-", then don't put anything in ths cell...

=IF(LEFT(A1,3)="tc-",A1,"")

I'll try to explain in another way: In the new worksheet I need a list of all cells starting with ONLY "tc-" and not empty cells.

Originally Posted by jraj1106

Hi

Try this:

Attachment 147527

95% what I need. Is it possible to have an update in stead of adding the values to the list a second time when the macro is run again?

Originally Posted by jraj1106

Hi

Try this:

Attachment 147527

is anyone able to adjust this macro? The list should be updated (do not add a value twice).

Thanks

Originally Posted by arlu1201

You can have the list cleared and re-input. This way, no duplicates will be present. Will this work?

I prefer an update if possible because other data will be put in the same rows and clearing and re-input might mix up the order

Originally Posted by arlu1201

Is the data in the same rows from other worksheets or the same worksheet? The data in the entire row can be re-input after clearing.

I'll try to explain: based on the first import I will add a date in the field next to a copied cell. After the re-run of the macro, this date should still be next to the correct cell.

I think I made an error in my thinking. This will not be possible.

Thanks for trying to give me a solution.