macro - auto run

I have been trying to figure this out for 3 days and am at the end of my rope. I am designing a spreadsheet for a construction firm. The workbook contains an the estimate, client proposal and the PO's for 3 different vendors. On the estimate I have a dropdown list for the vendor, category...

Hi All, I am not the best at VBA but am trying to get my macro to work. I have created a combobox drop down list in the developer tab. I want to be able to get the data selected in the combo box into another cell in my workbook, however I am having issues. This is what I have come up with so far...

Greetings. I have two sets of data in the Sample below. I am looking for a way to automatically create the Outcome: each value in Column A paired with each value in Column B - creating two new datasets in Columns C and D. The solution must work for much larger datasets. THANK YOU!! Sample...

Hello all, I'm trying to run all my worksheets from the Sheet1 (Report) with using just a button. Currently I have to go to each sheet and run them one by one. I'd like to have this automated. here is my code that I have in all 72 worksheets (I have this type of format "But different Ranges"...

I am trying to create a macro where I can automatically send my time sheet in to my boss with the time sheet attached. I have found out how to automatically send it but the file was not attached, and I found out how to send it with the file attached but I had to manually run the macro every...

Hi All, I have a tab (scheduled days to work) where I put in a persons name and what days of the week they say they want to work. What i want to do is once the data is put in like the first table below a button is pressed and it will automatically populate a whole new tab for the times they...

I am a pharmacy student in serious need of help for my internship. I need a macro/vba code that auto generates when there is cell content in a row of a worksheet. this number is going to be an invoice number. I current have a 'masterfile' that records all finalized orders for each facility...

Every week a new report comes out that I save as a text file and refresh in my Excel workbook, this is in sheet 1. As each week comes out, I start a new row and I copy and paste certain data from that report on sheet 1 to sheet 2. I was thinking that there must be a way to link the cells that...

i have a macro that does what i need it to do but it does it to one number at a time. Is there a way i can update it so i could put a list of numbers have have it do the process to each number? Please help Sub ZMain() Dim Text, ret SendHostKeys ("<TAB>") SendHostKeys ("<TAB>") SendHostKeys...

I need help with this spreadsheet. We cannot load the sound files on computers, so the files need to be embedded. They can be a wav or an mp3. The spreadshet is used to track projected hours for each store. Ideally we would like a cash register sound (green.wav) to play when the value is...

Hi there, I need a macro which can able to create an excel with 3 sheets based on the following criteria. <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Name Age Gender Salary Ram 25 M 10000 Ganesh 23 M 2000 Saleem 10 M...

Hi, I ned to keep a record of stock sold each week in a sportstoreI have two tabs. One called "Weekly Update" and the other called "All Stock". All Columns are named and formatted the exact same on both tabs. I need to do a Weekly update of stock sold on the first tab. This has 7 Columns and...

Hi I record this macro for auto refresh filter of table based of value of cell "B2" Sub Mysub() ' ' RefreshFilters Macro ' ' ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=2 ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=2, Criteria1:= _ "<>" End Sub...

Hey Mr.Excel I'm working with a Excel document containing a good portion of scroll bars. I have a macro that i run to update my data, and after the macro is finished I have to manually move all scroll bars. Therefore would hear if there was a way to get the scroll bars two move 1 value/date...

I need some coding help with a data entry form I've downloaded from contextures.com and customized for our company use. Sheet 1 (Input) is the data entry form, sheet 2 (RequestData) is the database sheet, sheet 3 (LookupLists) is for...Lookup Lists! Internal clients will fill out the form on...

Earlier today I was able to get some help in editing my code for repeating formatting in all workbooks except the first two. I have two additional asks/needs: 1) I want to copy a range (F6:L11) from the first worksheet into all the following worksheets in cell C18. 2) I want the macro to...

Hello, If I want to run a macro down multiple rows of data (sort of like autofill, but with running a macro), how would I do this? For example, lets say I want to copy A2, paste into a calculator on another tab, then copy and paste the output from the calculator onto a a different tab...how...

Hi I am creating one review record in this record I want to lock the particular cell of the data once the user was close the file (Save & close it ) . Example : There are column A B C in the table once the user enter the information in A1 B1 C1 and he saves then if he want to edit it he can do...

Hello Experts, I am working with 4 columns where I am in need of a formula where it will check if the director or directors of one company is exactly exist with the same name along with the same number of directors with the company just next to the first one. Let me explain it with a few...

Hello Experts, I am working with 4 columns where I am need a formula where it will check if the one director or directors of one company is exactly with the same name and same number of the company just next to the first one. For example please check the below table where for the both company...