VBA macro Related Problems & Solutions

50 tags
Refine Tags

Start a discussion

Results 1 - 30 of 50
[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...

[Solved] Checkbox Macro for Excel Depending on Tab Color
Summary: I have a workbook with mutliple worksheets. When a worksheet gets updated, we change the tab color so we know which sheets have been updated. On th...

[Solved] Macro change tab color based on font color
Summary: I was hoping someone can help me with a Macro. I have an Excel Spreadsheet that has numerous tabs. Throughout the workbook there are cells that have ...

[Solved] Delete rows with specific dates using macro?
Summary: Hello everybody, I have 10 excel workbooks each with numerous worksheets within each, labeled 'stock 1' to 'stock 45' for example. Now within each wor...

Excel Macro Help Insert Rows, Sum Data
Summary: I have started recently to mess around with macros but I can't quite figure out how to do this one. I have this list of songs with three columns (art...

12


Ask Question