macro - auto run

I am doing right now the Daily activity report of our team and I need to consolidate and track the time stamp of each activity. My problem right now is once they filled up the activity with timestamp and after entering to a new activity, I would like to protect or not able to edit the previous...

Hi All, Can you please provide me macro or code in Excel to replace Special ASCII Characters into Alphabet. EG. For À, Á, Â.. i need Alphabet as A.. and for ß, Ɓ, Ƅ.. i need Alphabet as B. Can i replace these special characters with correct English alphabets. Let me know once you have any...

Hey folks, I am a novice to excel vba. I need help from experts like you I have to develop a macro, where i could update the values of closing stock on weekly basis. Lets consider the macro excel file as Macro1.xlsm and the file containing the closing stock Clsg2.xlsx My methodology is...

Here's what's currently going on. Workbook A: Contains data, and Macro A which calls Macro B in Workbook B Workbook B: Contains no data, but contains Macro B which takes data the file which calls it, and spits it out in a text file Business requested the data and macro as in separate...

hello i have created a userform , the function of the userform is like first when i enter the value it will be entered into the sheet with specified rows then next if enter just few fields it will copy the value of cell above and paste on the current cell.When i run the program it works...

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...