VBA macro Related Problems & Solutions

54 tags
Refine Tags

Start a discussion

Results 1 - 30 of 54
[Solved] Emailing through excel vba.
Summary: Hi, I have already got a functioning email macro thanks to the help of DerbyDad03. Now i have another problem. When multiple emails are selected to ...

[Solved] Selecting specific emails to email through vba
Summary: hi, I have a table of contacts for people consisting of their names, number and emails etc.. I have already worked out how to send emails through a v...

[Solved] Macro to copy cells then paste only values in a column
Summary: Hello, I would like to be able to copy a variable range of cells (rows and columns) with many blanks into one column with only the data (skip the blan...

[Solved] Merge cells into one cell
Summary: Hi, Can someone help on how we can merge multiple cells into one single cell? Can this be possible in macro? Below is the raw data Supplier No Suppli...

[Solved] (Easy) Excel VBA Conditional copy paste components of a row
Summary: Hey there! I am looking for a way to automatically copy paste values from one sheet to another based on the contents of the column in the following wa...

[Solved] Excel Macro to match set of values to another through edits
Summary: Hi folks! I've tried my hand with some macros and done OK but what I want to do here is beyond me and need your help! What I'd like to do is search th...

[Solved] How To Bold Variable Text In A Concatenated String In Excel
Summary: I have applied the code from the question posted March 20,2016 (http://www.computing.net/answers/office/how-to-make-bold-fonts-in-a-concatenated-text-...

best % data compression using only printable 8 bit ASCII
Summary: The target is a JavaScript .js file putting the result in a variable that can be read. This limits the characters that can be used. I avoid base 64, H...

Copying data to another worksheet based on criteria. - VBA
Summary: Maybe I'm just over thinking this, but I couldn't find anything about it anywhere. What I'm trying to do is copy a range of cells from a table on one...

SUMIF formula to VBA
Summary: =IF(SUMIFS(FTMRC,FTMRC,VALUE(40),CTN,RPA!E5),40, IF(SUMIFS(FTMRC,FTMRC,VALUE(45),CTN,RPA!E5),45, IF(SUMIFS(FTMRC,FTMRC,VALUE(30),CTN,RPA!E5),30, IF(SU...

How do I add rows of data to new worksheet from data dump
Summary: Hello. I am looking for copy data based on criteria into a new work sheet and format it at the same time. My data is a database dump with thousands up...

[Solved] auto populate text from data validation list
Summary: Hi, I want to auto populate my data in column H. It's a vlookup in macro. I have a data validation list in Column G from row 12 to 100 and I want to a...

[Solved] Look for matches between 2 worksheets in Excel 2010
Summary: I've been attempting to write a macro to do a comparison with a copy function when a match is found. Hopefully this helps explain it: Situation: Work...

[Solved] Excel macro to highlight every row above every empty row
Summary: I have an excel data sheet which is divided into data blocks of variable number of rows. Data blocks are separated from each other with an empty row. ...

VBA Lookup by Multiple Criteria - Then Copy & Paste Row?
Summary: Currently I have a 2 way database with 10+ fields and 1,000+ rows. Some fields are customer name, car model, year of model, price, date of purchase. I...

How to sort data in active row using VBA in Excel 2010.
Summary: Hi My problem is as follows. I have many rows of data and the data is stored in columns A:M. Some of the cells in a particular row needs to be delet...

[Solved] Code to delete specific sheets in a workbook
Summary: I need to delete specific sheets in a workbook and run the rest of the code even if the sheets don't exist ...

[Solved] VBA Sort Data, then Copy over the New Sheet
Summary: So I have the simple spreadsheet named "Result". A B 1 009584 Over 2 0065...

[Solved] VBA to replace Vlookup
Summary: I have a similar case for this one that I searched around (http://www.computing.net/answers/office/search-a-field-and-assign-a-label-based-on-results/...

Sorting macro is not working
Summary: here i attached the sorting macro i have written for sorting the answers. I have four series question paper i.e. A,B,C and D. please help me out here...

[Solved] How to copy all data from one sheet to another excel vba?
Summary: What is the correct way to copy a whole sheet to another existing sheet in the same workbook? i would like sheet4 to store my data and copy it to shee...

[Solved] Need to search a list of text in excel by multiple criteria.
Summary: need help searching/filtering a list of text values in excel, using multiple wildcard criteria, and return all matches. http://www.computing.net/answe...

Copy specific rows and paste into new sheet
Summary: Greetings, I am using excel 2010 on Windows 7 and I am trying to perform something I thought to be simple. I would like to search each row for a spec...

out of office: mails delete outlook macro
Summary: Hi Team, I want to delete the Outlook messages which has Subject "Out of Office:", with help of VBA Macro. Thanks in Advance Venku ...

Copy all columns that contain a value in the header
Summary: This question has been partially answered here: http://www.computing.net/answers/of... This macro copies the first column that contains value 'x', but...

excel: want to scroll to a row for day 1 of current week
Summary: I've got an excel spreadsheet I'm using as a running log and A4:A369 contains all of the dates of the year. I'd like to automatically scroll when shee...

Adding rows based upon different numbers number
Summary: Hello, I have a data sheet where the number in Column C is a number that fluctuates between 0 and 64. I need to be able to add (x-1) rows above it. So...

Is there a way to vlookup and keep formulas?
Summary: Hi all, I have been recently trying to find a way, through VBA, to VLOOKUP and keep formulas. I have quite a lot of data to check and so far haven't b...

VBA excel Inventory Report
Summary: I am trying to build a program in VBA for excel to solve the following problem: I am given 10000 numbers from A1 to A10000. I need to write a macro t...

Help making buttons that move data & call external programs
Summary: I need help with a few buttons. First my data A B C D E F company1 address1 city state zip phone# company2 address1 city state...

12


Ask Question