record macro

Hi all, I currently have these values in a larger format from rows J - N. I have made a small example of my data here: I essentially want to swap my "." with my "," in every cell, if applicable. If not applicable, I want to replace my "." with a "," and my "." with a "," Does this make...

Hi all, I am very rusty in Vlookup (embarassing!) and I am currently looking at this data: I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G. I...

Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...

Hi all, I have this macro that i recorded, and it produced this code: However, when I use it, it just erases everything in column E and does not paste the data from column F at all! please help me fix it`?? this is my setup, with the macro being called "update", as you can see, my cells...

Hi all, I am having a huge issue at the moment with some macros i created (through record macro). Basically, I have this excel sheet: I tried to record some macro's, where once I press unfreeze, they post this formula: =IF(ISBLANK(B9),"",TODAY()) for the left one...

Hi all! I currently have this setup in Excel: And the code is this: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim...

Dear all, I am currently working on a spreadsheet that looks like this, albeit the real one is much larger: I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...

Hi, Is there a way to add in an existing VBA code a new macro but from record macro function?+ And if so, how? Thanks in advance:)

Hello, i am new in the forum, i would like to ask how we can make a cell do a specific action. Example i am using Excel 2010 and have text in a cell i want to press the cell and this text to go automatically in the search of Thunderbird in a specific email's address inbox. If i am not...

how can i make macro work on different sheets and different cells . example im going record macro then im going to change the color of cell A1 in sheet 1 then i will stop the macro then i will run the previous macro that i have recorded in sheet 2 but i want to change the color of different...

I have to prepare 70+ tables from a data set. In order to take the same information from the data set, I have created a validation list dropdown (in cell A2). The next step (that I need help with) is recording a macro that prints the first table, then selects the next item on the list and prints...

I am currently working on a macro that will decode the cell above it with an "if" statement. There are around 60 different possibilities, so the statement is long. I typed the equation into a cell on excel. From there I recorded macro, and entered it into all the needed cells in the workbook...

hi there! i want to create a button that will COPY the cells "Sheet1!A1:D2" to "Sheet2!A1:E1"... i tried recording a macro with that but i always get a WARNING... can someone please help me with this, i dont want that warning to pop up again... plz...thanks :)

Hi, My formula works when I type it in. However, when i try recording it "unable to record macro" appears. I read somewhere that excel doesn't record macros if the cell has more than 255 characters...

i want to write a code that generates data and add a chart. i tried recording a macro (subroutine) but i read that excl2007 has problems. so the x values go from 1-100 on column A and y=(2*x)+7 on column B. then from this data i want to add an xy scatter with smooth lines. then i want to format...

I have Excel 2003. I have 2 different data fields being pulled into the area vol_net and vol_gross and for some reason when there is a lot of data the table freaks out and comes up with the orientation error. With ActiveSheet.PivotTables("PivotTable3").PivotFields("vol_net")...

Hi everyone, Hopefully someone can help me with an issue I have with macro recording. I'd like to record a macro which: 1: copies the text string in a cell 2. filters a list based on that string 3. opens a pre-created workbook whose filename is based on the original string 4. copies the...

Hello, I came across a problem with my macro and decided to record a macro and see how excel did this, the result: Range("G14,I14").Select Range("I14").Activate ActiveSheet.Shapes.AddChart.Select however, when I run this macro i get the 1004 error on the last line?! The last...

Recently changed machine, but still running XP with Office Professional 2003. I've recorded a couple of macros but now whenever i open a file, or try to run the macro in a brand new workbook, it automatically opens the PERSONAL.xls file. I've checked the VB script and there is nothing in...