How copy text in cell if bold and them paste it into another cell on another tab????

[kjicha]

Hello,

I am in need of the following:

I need to find all the bold text in Column C starting at row 3 and go through till 1000 rows on a tab called "Requirements". Then Copy that text and paste it into another tab called, "Overview", but into a merged cell (which is C & D starting row 29 on this sheet).

Hopefully you can help. Thank you.

 

[mrmmickle1]

You're welcome. Glad to help out.

 

[kjicha]

Now what about this

I have created a user form. In this user form I have a Ref # (which pulls in column A for that requirement), Hierarchy field (pulls in column B for that requirement), Prioir Requirement (which grabs the requirement that is in Column C), Version field (which right now the user puts in a #). On this worksheet ("Requirements") the rows start on 3. When the user is on a cell in Column C, lets say C3, clicks my macro to open the user form, I want the version field on the user form to check in the "Version Control" tab to see if the Ref # field in column A matches the Ref # in column A on the "Requirements" tab. If it does, then get the Version value in Column D in the "Version Control" Tab and up it by 1 or would rather it be 1, then 1.1, then 1..2, etc...

Hope this makes sense