How To Create a Command Button

**oneal1177** · 05-22-2017, 11:50 AM

Hello I'm new here and looking to get better at excel. I work in the oilfield which we use dailies to record what is going on through out the day. I trying to create a command button that will allow me to create a new daily each morning and paste the existing information onto that day. For example I want the new sheet to be named Day 2 and have my templet have all of the important info transferred with it along with the command button. Also I'm trying to figure out how I can transfer my total hours to my previous hours when creating a new sheet. I have attached a copy of my excel file so feel free to play around with it and see what you can come up with.

**mike7952** · 05-22-2017, 11:55 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**mike7952** · 05-22-2017, 12:42 PM

Can you fill out Day 1 sheet and show what Day 2 would look like? And what is to happen with Job Info sheet?

**mike7952** · 05-22-2017, 02:02 PM

Instead of adding a button to each sheet I added a Button to the Ribbon. You'll see a Custom tab with a button to create a new sheet. There is a pop asking for new sheet name. Its just a start, and doesn't transfer hours yet. Need to know what needs to transfer and where you have formulas in Day 1 sheet are those to be copied as a formula or just the values?

**protonLeah** · 05-22-2017, 02:54 PM

withdrawn.....

**oneal1177** · 05-22-2017, 04:43 PM

Thank you for doing that Mike that is a great start. I was wanting a button so when I present this to other employees they can just see it and click on it.
I think it would be just easier to explain it. Also, the Job Info tab is where I grab all of my basic job info like client name, rig name, who is on the job,
and job details. I have filled out Day 1 and 2 so you can get a general idea of what I'm looking to do. Where I have my tool hours I would like for my total
hours to automatically transfer over to the previous hours box when you click on a new daily button and to zero out the total hours. The same for the depth.
Attach is an example

**oneal1177** · 05-22-2017, 04:48 PM

Originally Posted by oneal1177

Thank you for doing that Mike that is a great start. I was wanting a button so when I present this to other employees they can just see it and click on it.
I think it would be just easier to explain it. Also, the Job Info tab is where I grab all of my basic job info like client name, rig name, who is on the job,
and job details. I have filled out Day 1 and 2 so you can get a general idea of what I'm looking to do. Where I have my tool hours I would like for my total
hours to automatically transfer over to the previous hours box when you click on a new daily button and to zero out the total hours. The same for the depth.
Attach is an example

Oh and to update the date.

**mike7952** · 05-23-2017, 02:50 PM

See if this is does the job.

**oneal1177** · 05-23-2017, 03:33 PM

Yeah you got the hours working great but it doesn't keep the formulas in when plugging in new hours or in the time column. Also it doesn't update the date or the total footage drilled box towards the bottom. How can I see the code? When I opened up Visual Basic I just saw a blank page.

**mike7952** · 05-23-2017, 03:43 PM

Highlight the cells that need to be fixed. Over to the left you should see the worksheets modules and standard models. You'll need to open the mod_ module.

**oneal1177** · 05-23-2017, 04:03 PM

Ok I highlighted everything in an orange and Day 1 has the formulas that belongs in those boxes. I'm trying to update the date when creating a new day and to transfer the total footage over to the previous footage like the tool hours does.

**oneal1177** · 05-25-2017, 04:31 PM

Mike are you still there?

**mike7952** · 05-25-2017, 04:39 PM

Yes lol, I work 12/hr night shift and tonight is my last night. I will finish this up tomorrow afternoon. Sorry for the delay.

**oneal1177** · 05-25-2017, 04:52 PM

It is all good I appreciate all your help.

**mike7952** · 05-27-2017, 10:22 PM

See if this works for you.

**oneal1177** · 05-28-2017, 04:42 PM

That works great but it still doesn't transfer the formulas over. I highlighted what boxes need to have formulas in them from Daily 1.

**mike7952** · 05-28-2017, 04:50 PM

Okay, cooking out now will look at sometime tonight.

**mike7952** · 05-29-2017, 09:12 PM

I didn't even see the formulas before. This should do it.

**oneal1177** · 05-30-2017, 10:39 AM

That works great. Thank you for your work. How can I change the name of the tab?

**mike7952** · 05-30-2017, 11:46 AM

Name of what tab? The new sheets created? Just type new name into input box.

**oneal1177** · 05-30-2017, 12:11 PM

The My Oilfield Tab on the ribbon. I would like to change it to read Reports.

**oneal1177** · 06-01-2017, 02:14 PM

Mike are you still there?

**oneal1177** · 06-09-2017, 05:57 PM

Hey Mike how can I get the daily to create the new sheet the other way? For example the tabs go Day 1, 2, 3, 4.... but I want them to go Day ....4, 3, 2, 1

How To Create a Command Button

LinkBack

Thread Tools

Rate This Thread

Display

How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Re: How To Create a Command Button

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to create command button. Print all sheets then delete command button.

[SOLVED] Command button to create a pdf

Create a command button with code with a command button

create a command button

create a command button for an add in

Create a Command Button

[SOLVED] command button:. how can i create a command button

Bookmarks

Bookmarks

Posting Permissions