help macro

Hello, I'm just getting started with trying to write macros for Excel. I have minimal JavaScript knowledge, so I understand parts of it but I'm not totally sure of the correct language. I'm trying to create a macro that will reference another cell and add a value in a different cell based on...

Can someone help me understand why? Problem This code does not work Sub Cover() ' ActiveWindow.ScrollWorkbookTabs Sheets:=12 Sheets("(3) Cover Sheet").Select Range("F41").Select End Sub This Code does work Sub GoTo_Tab_11() ActiveWindow.ScrollWorkbookTabs Sheets:=12...

So I keep getting a "Run-time Error "9" Subscript out of range" on the third line (marked in bold) and I don't know how to fix it. Any thoughts? Private Sub CommandButton1_Click() Dim LR Worksheets("Sheet2").Activate LR = ActiveSheet.Range("B" & Rows.Count).End(xlUp).Row + 1...

I have been trying to create a macro which will copy all the data from certain columns in a table (B to G) between row 24 and the next empty row (as the table found on a sheet called "Data" is updated frequently so the final row of data will be moved further down the sheet). then pasted onto...

Hello, I have 2 excel sheets in 1 workbook. Sheet 1 is the original version and sheet 2 is the updated version. I would like to compare both. What I'd need is a VBA that will highlight what has been added or changed from sheet 1 to sheet 2. The highlights would need to appear on sheet 2. Just a...

Hi Everyone, I have 21 workbooks (i., 1.xlxs, 2.xlxs......21.xlxs) each with 8 worksheets(sheet1,sheet2....sheet8) I am trying to merge the data from all the workbooks into 1 workbook. The resulting workbook also contains 8 worksheets and the combined data from the workbooks for each sheet...

Hi, I have been trying to record a macro to do the following: 1. Create a new column (always before the last column of the table) 2. Drag the formula from the previous column to the new one. Example: Columns: A, B, C, D, E Need to create a new column always before the last column (E) so...

Hi, I am a rookie at Macros! I am using Excel 2013 on Windows 7. I am currently trying to summarise average temperatures for each day of the year. I have downloaded the data from an onine BMS interface which gives the temperature every 15mins (up to 100 samples per day) so trying to find the...

I am going to assign a macro to a check box. right now I have it so that the when the check box is checked F5 will say true, and if unchecked it says False. Now what I want to do is: if F5 says True then C5,D5,E5 will remove any text in the cell and populate with N/A. If F5 says False then...

Hello, I am very new to VBA and am looking for some help with something I'm trying to figure something out. Here are some details: I have "Table1" in a sheet called "Interviews" I have "Table2" in a sheet called "Main" "Table1" Stats: Columns A-I. Headers on Row 4 and first Data row is 5...

Hey there ladies and gents, I would like to write a VBA code that would take the all the cells in a column, column B, and see if all of these different cells are anywhere as a string in column K. The only problem I continue to run into is the fact that there are more or some missing characters...

I'm sorry if there is a thread like this, but I have looked at a lot of thread and none of them have worked for me. I have two columns. the first column has names and the second column has information separated by a line break (Alt + Enter). It would look something like this: A1= Joe...

Hi everyone, So I have a code that copies info from several identically structured downloaded worksheets onto a master sheet. However, I can't seem to edit the code properly so that I can add 4 more columns of info, in a specific order, to the master sheet . Im attaching the downloaded...

I am a records management auditor, I recently switched to using Excel from other programs and I am hoping there is a way to make my life easier, What I want to do is scan a barcode with a barcode scanner and have it find the barcode in my Excel workbook, and then populate a cell a few columns...

Hello my fellow Excel enthusiasts. I've put together a dashboard with three charts: 1) Bar Chart 2) Line Graph 3) Pie Chart I'm tracking sales figures in total, over time, and the makeup of those sales (what products were sold) in the three charts, respectively. As of now, I'm controlling...

Hi I have one spredsheet where the date, name, team, results are recorded. <TBODY> Date</SPAN> Exec Name</SPAN> Team</SPAN> Internal Process</SPAN> Client Impact?</SPAN> Final Status</SPAN> 27/01/2013</SPAN> Miguel Luis</SPAN> Tools team</SPAN> Fail Yes Fail 28/01/2013</SPAN>...

In my current macro I have ~50 worksheets that I need to open/update links and print in a specific order on a shared drive. It takes me 5min to do all of this. Is there a different combination of variable/commands to print these quicker? :( Here is a sample of my Macro: Sub Sample_Morning()...

I have a report that (among other things) has two columns: Column A = Order Number, Column B = Yes or No I need to find out what orders (Column A) have both a YES and NO. For example I would run the macro against the grid below and it would return 24567 and 24570 in a thrid column (because...

Sub FollowLinks() Dim i As Hyperlink If (A1) = " http://www.ecb.int/stats/money/aggregates/bsheets/html/outstanding_amounts.zip " Then OpenLinks " http://www.ecb.int/stats/money/aggregates/bsheets/html/outstanding_amounts.zip " End If End Sub Can...

Hello, I am trying to write a module that runs when a new page is created. I want it add a sub that activates before you double click a cell. This is the code that I have wrote so far. It does not let me run it because of a syntax error. Sub AddCodeForRange() With...