Macro Removes Formula

Hi

Someone kindly wrote this macro for me a good while ago. It has served me well to date

In essence, this macro looks at column A, and at every instance of a value
it either
creates a new sheet within the workbook, names it, the copies the entire row
OR if there is a sheet already just copies the entire row

Please Login or Register  to view this content.

However something in the code is copying just the values in the cell to the new sheet, and I need it to retain any formula

Any suggestions?

Thanks

The use of advanced filter copying to another range is removing the formula.

So you need to filter in line and the copy and paste visible cells.

Will the copied cells formula work when moved to another location?

First off, if you copy a record with formula to another location will the formula still make sense and return the correct/same information?

If so can you post a set of sample data.

try this revision

Please Login or Register  to view this content.