code automatically

Will someone please help me with writing of the code for a macro? I would like to run it on a newly opened document. Basically, I want the one column to use all of the rows which contain the same numbers, to give me a total of the corresponding rows' column. E.g A1,A2,A3,A9,A15 are the same (...

Hello! For a school project, we are going to make a machine that will register bottles recycled, and give a prize to random recyclers. We have got a solution that can scan barcodes and paste them into excel in a vertical row. Every student also has a id-card with a barcode on. What we need...

Hi! Basically, I have an Excel sheet for project tracking and when a project is marked 'completed' I want it to automatically move to the "Closed" tab. I was able to get a code to work from a previous poster, but have no idea how to write my own so I can't edit it to fit my needs exactly...

I have created a spreadsheet of about 80 or so tabs. On each individual spreadheet, in a specific cell, I have a percentage that is populated. In another cell I have the "IF" formula to populate OFF TRACK or ON TRACK based on what the percentage is. I used this formula in the macro view code...

Hi, I am editing a huge Word Doc for my airport, which has many sections. However some sections started on Odd pages. I found online a Word VBA code (image 3, link to png image below), and it seems to be the only one out there, that does the job of adding a blank page to those Sections...

In deleting the last record in a spreadsheet, it is causing the following error: "Run Tie Error - Cold not set the value property - Type mismatch The following code using to delete

Hi All, I have a code for EXCEL VBA that searches for email messages in certain folder of Outlook ( both 2007 version). However, the comparison starts from the lastest email in the folder and not from the first email. ( in Outlook, I prefer to keep the email messages sorted as Newest first and...

Hi, I am trying to have a vb code for copy & paste data from multiple worksheets to new work book called as "ConsolidatedDetails". All multiple workbooks has three sheets each and macros have to copy & paste data from all three sheets. If there is no data in any of the three sheets it should...

Hi there, Wonder if someone can help. I cant get the code below to run automatically everytime "I" is changed Sub looping_code() Dim LR As Long Dim i As Long LR = Range("G" & Rows.Count).End(xlUp).Row For i = 1 To LR If Range("I" & i) = 90000 Then If Range("G" & i) >= 90000...