VBA find & offset to copy/paste to other worksheet

Hi mdolinger,

Based on my understanding of your description, try the below code which I have provided the sample file I worked on

Please Login or Register  to view this content.

I am not really sure I understand your request. Your file doesn't have a "Master" sheet, are you referring to "Bid Sheet" ? What do you have in cells B9-B29 ? In which sheet ? Could you be more specific or better yet show in the file an example of before & after

This is what I understood so far & correct me if I'm wrong before jumping into writing the wrong code

Steps below

1. Make a copy of sheet "Bid Sheet"
2. User manually fills in "Description" in column B which could be 1 or more items
3. Run a macro that will loop through items in column B, update cost & mark up from respective sheet based on column B

I don't see any connection / or what to do with sheet "0MAX2RE"

@nankw83 I really appreciate your time. I manually fill in the "Bid Sheet" with different items for that bid. I fill out columns A, B, C & D for each bid item on the "Bid Sheet" of the workbook. I would then copy the 0MAX2RE template, name it as the item I just filled out in Column B on the "Bid Sheet" I then link the cost and markup from the new sheet I just copied and renamed to the "Bid Sheet". On the testworkbook, I have filled out the description and then I've also copied the worksheets and renamed them. I am trying to get a macro to copy "0MAX2RE" for every bid item on column B from the "Bid Sheet", then hyperlink the new sheet to the description on column b, link the cost from the copied worksheets to the bid sheet and link the markup from the newly copied sheet to the "Bid Sheet" The test workbook is what I'm looking to accomplish. I manually copied the 0MAX2RE, renamed then, and then linked to the bid sheet. I hope this is a better explanation. I am using this code now to copy sheets, but it doesn't do the linking. It's not pretty and I'm not a fan of the error handling, but it is what it is. Thank you again

Please Login or Register  to view this content.

I was trying to get the original code to work, since the cost cell is always one down and one to right of the "MARK-UP" Cell.