Need help with ActiveX Button and VBA Code

Hello,

I have a pretty complex issue I'm trying to figure out at least its is for me.

I have several things I'm trying to make a happen.

I will attach an example of each.

I hope I can make some since.

First thing I need to happen is a Active X button that when clicked on, it will import data from the "OST Import to S.E.B.W." the "Main Sheet for data to end" in which is called "Erection Estimate Base" Bid on real workbook.

As you will see in the "OST Import to S.E.B.W." & the "Main Sheet for Data to end" in which is "Erection Estimate Base Bid"

there is tasks IE....

ERECT Ave. 6-10" Standard Beam
ERECT Ave. 12-14" Standard Beam
ERECT Ave. 16-21" Standard Beam

etc.....

So basically what I'm trying to do is when the quantity of the task is entered into the "OST Import to S.E.B.W." sheet and only if there is a quantity entered in upon clicking the Active X button the same quantities will come into the "Erection Estimate Base Bid" sheet in the corresponding cells as you will see both attached example sheets are the same.

Reason why I need to do it this way....

I'm using a takeoff software to compile the quantities, that program will export to the "OST Import to S.E.B.W." the reason I can not just export to the "Erection Estimate Base Bid" is it is protected and will be installed as an app, so when using the takeoff program you can not select that sheet to import in to, so I need to create another IE... "OST Import to S.E.B.W." to import into and then once the sheet that is installed as an app is open I want to be able to click on the Active X button to pull the data off the "OST Import to S.E.B.W." sheet into the one in the protected program sheet called "Erection Estimate Base Bid"

I hope this is making some kind of since I have no idea how to put everything together to achieve this and know that there are some pretty sharp folks in this forum as they have helped me in the past when I have hit a wall.

Thanks so much in advance.

Thanks for the response jaslake

They could be the same number wise as in updated attachment IE 306 an 306 only thing on the main page that it will be going to last, it would be starting at cell #88 and not #1 cell

Thanks for looking at it jaslake

Thanks jaslake,

As far as active X I'm just looking for a way to do what I need to happen.

I'm thinking after seeing what you did there that it is going to be more complex then that. Here is why I say that.

First "OST Import to S.E.B.W" will be different cells IE "OST Import to S.E.B.W" will be numbered 1 - 306 the sheet that will be receiving the data will start at number #90 to # 395 with some cells not getting data entered as they are a heading of a category of task.

The second thing is, the sheet that will be getting the data IE.. "Main Sheet for Data to end" will not remain the same sheet in fact it will change with every project which is why I was think in the main sheet to have a button when clicked it would bring in the Data from "OST Import to S.E.B.W" and be coded to land in the appropriate cells in the "Main Sheet for Data to end" sheet or what every that name would be for various projects.

The cells in "OST Import to S.E.B.W" will always be numbered 1 - 306 and the cells in "Main Sheet for Data to end" will always be #90 to # 395 with some cells not getting data entered as they are a heading of a category of task. And those cell that would not receive data could be identified.

Hope I'm making since.

Thanks so much for your time looking into this. If we can make this happen just realized there is a pay option in another area and if you are willing to tackle this I would be happy to go that route as well.

Works for me but with "Main Sheet for Data to end" not remaining the same sheet name would that create a problem doing it this way. How would you write that into a code if we do not know what the end destinations sheets name will be? As it will be different every time

I will send example of both sheets so you will see the numbering in both. If we need to take this to the paid side how do I do that an how many points do I need to make this happen. I will most Lilly need some direction on where to place code once it is completed

Thanks

Okay lets see if I can get this across.

The Main Spreadsheet is an estimating program. The reason the name will be changing is every job that you do an estimate on is named different IE.. Walmart, costco, ABC Warehouse etc... it will all depend on the Jobs name that you are doing an estimate on to what the sheet will be named.

I use a company called On Screen Takeoff to do the takeoff of the drawings which creates the quantities that will be sent into the "OST Import to S.E.B.W" sheet. That program (On Screen Takeoff ) gives me the ability to import into excel BUT... here is the problem the SEBW program ("Main Sheet for Data to end") is excel based but will be wrapped inside of a program that is installed on the computer as an app once it is launched it runs just like excel but you can not import to it as it is protected so there is no way to find it from the OST program when you search it because it will not open until it is launched.... which is why I'm trying to find a way to put some type of button inside the "Main Sheet for Data to end" that once the "Main Sheet for Data to end" is launched and the button is clicked it will call the data from the "OST Import to S.E.B.W" sheet and bring it into the ("Main Sheet for Data to end") sheet to the appropriate cells.

And yes I can control where "Main Sheet for Data to end" and "OST Import to S.E.B.W" lives