Selectively referencing formatted text (bold cells) from one sheet to another

[Stndsh]

I am trying to copy certain rows from one sheet (Sheet 1) to another (Sheet 2), but only rows in Column A (of Sheet 1) with Bold formatting. Please note that in both Sheet 1 and Sheet 2 there will be rows added and/or subtracted from between the rows with Bold formatting.

This excel file will be used for a construction management office. It contains certain information (Bold formatted) on the Scope of the project (Sheet 1) which will transfer over to a Budget (Sheet 2).

[gjlindn]

I don't think there's a native excel function that will allow you to do that. If you're willing to use VBA here is an example of code that will do what you're looking for. This assumes that the bold cells are in column A.

Please Login or Register  to view this content.