excel - vba

I have a VBA macro written (it's at work so I don't have it here) that creates a hyperlink based on a cell value. It is used to call up data related to the cell value. The displayed text is the cell value. It works fine. Next I create a pivot table that includes the column that this data resides...

Hey Everyone, I am having some issues with my VBA code. I have already coded half of it and it's working fine. I need to have the contents of my 1st and 2nd worksheet generate onto the 3rd worksheet. Now here's the catch, I need it to see if there are any differences between the data on...

I need help please. I want to ensure cell text is AllCaps within a range. For reasons I won't go into, I cannot have code in a Module so it's on the Worksheet itself. I suspect it's something to do with the sub listed below. I can enter a letter in a cell, select another cell to trigger the...

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected - Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular file directory. I don't want these worksheet names to change nor the workbook name to change. The...

Hi I am writing this code and getting stuck at line oChart2.SetSourceData Source:=PT2.TableRange1 Dim data1, data2 As PivotCache Dim PT1, PT2, PT3, PT4, PT5 As PivotTable For Each ws In Worksheets If ws.Name = "Bidding" Then Application.DisplayAlerts = False Worksheets("Bidding").Delete...

Hello. I need to find the cells in column A that has the word Total in it, and if that row has the word Total in it it will replace the value of column C with 1. Here's my sample table: <tbody> Team Purchaser Total Foot rugs 25 Amplifier Total 0 Sandwich 984 Can opener 659...

Hello, I have two ranges: N11:N510 and S11:S510 that can change (vlookups) based on a data validation list in Cell E8. Regardless of the value in E8, I only want the worksheet change to trigger if a value in N11:N510 or S11:S510 changed. If the change macro determines that a change has...

I'm using shapes.addline method in a sub to draw a line, passing in 2 ranges rFrom and rThru, and then using .top and .left on the ranges to supply the four points for the line. Seems pretty straightforward, but the line sometimes comes out at an angle when I've passed in ranges on the same...

Hi Everyone, i have macro code that calculate excel sheets and paste answer in dashboard row, each new excel sheet data paste in new row after calculation. i want to short this code and will be working lot of sheet and row. i means it continue when any new sheet create its done calculation and...

Hi all, Im not the greatest with Excel VBA but i have put together a small programme to send an excel range via an Outlook email using send keys and then to return to excel and do something else. The progamme works perfectly in isolation (Excel to Outlook -End) But when i add excel code to...

Hi Everyone. i'm facing some trouble how to manage this because i'm new in macro. here is details what i want to do. is very know about this please help me . 1) Use “Column I” in “adt4-16 - 4-22” tab to calculate the total number of minutes per data item. 1a) You can convert the text format...

Hello, I am building a dashboard which contains a revenue overview (monthly). The user of the dashboard selects the start month and end month (e.g. January - July). It would then look like this SERVICES January February March April May June July Total Product1 152345 435156...

Hi Team, I was working on this XML file creation through VBA and I am stuck at a stage where I have to write the contents to notepad recursively. For instance, i have some 10 XMLs to prepare and I want each XML to be copied in a new notepad respectively and saved with .xml extension...

I am hoping someone can assist with creating the macro I am attempting. I would like to have explorer open, allowing me to map to the file location to pull the file in. Once the file is opened I would like the macro to organize the data so that like coverage names are placed in the correct...

I can currently get my script to write all highlighted data into a file of my choosing. What I need to do is write it to the word documents existing table. It writes straight over it at the minute and I'm not 100% on how you reference the table you wish to use. My code is below Private Sub...

Hello everybody, I'm hoping there is someone who can help me. What I am trying to do is create a macro that will once activated finds the cell with a specified text (in this case "Platinum Premier") then goes down the column from there checking for cells that are filled, copy the data (text in...

Hi all, My data is sorted according to date. Date lies in a single column. Now, I want to apply my code to one month and get output and then it should run for new month. Is there anyway to do this using vba editor?

Code Example: Sub getLookup() GetData "\\myserver\SourceFile.xls", _ "2015", "A3:AW4", Worksheets("Lookup").Cells(3, 1), True end Sub I use the getdata several times to copy a range of data from a closed workbook to my current workbook and it seems to work fine for me in Excel 2010 except...

Back again! I'm hoping that someone can help. I have a worksheet where I am copying the values that the user double clicks on and I want an input box (if that's the correct thing to use) to allow the USER to advise the named range to paste special the value to. Currently there are three named...

Can anybody help me edit? I want to copy from column to another workbook column using array. The range inside the array is the Alphabet of the column i want to copy/paste. The bold part is the one where I'm stuck at.. Sub setting2() Dim wb As ThisWorkbook Dim here As Workbook Dim there As...