Excel macro Related Problems & Solutions

46 tags
Refine Tags
Search Tags:

Start a discussion

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

Excel Macro to color certain phrases within a cell
Summary: I have a list of banned words and key phrases. I have a macro which will change the font of the word to red for those in the banned words list; howeve...

[Solved] Copy row except column 'I' to new sheet when value is true
Summary: You can see my initial post (explaining the sheet) Here: http://www.computing.net/answers/of... This is my current code: Dim NextRow As Integer Pri...

[Solved] Copy entire excel row to a new sheet if a value is true?
Summary: I need a code for the follow scenario: Also if you can kindly help with how to input the code. Thank you in advance. My Sheets are Titled: Sheet 1...

[Solved] VBA to use PasteSpecial instead of Paste Destination
Summary: Hi, I have the following macro that will copy and paste form one worksheet to another. I would like change this to paste the values and I have not be...

[Solved] Data Validation Intersect vba
Summary: hi.. i have a template where in 2 columns are related to each other. I want to automatically create a validation list for the other column based on wh...

[Solved] random sampling excel vba
Summary: Hi, I actually have a data where there is 2 classification - Approve and Missing I need to have a random sampling 50 for each classification but these...

[Solved] how to find block boundaries with spaces included
Summary: I frequently have to find the boundaries of a block of data in an Excel s/sheet within an Excel macro. Several methods exist. I now have a situation w...

[Solved] Excel Macro to color certain words in a line of text
Summary: I have a list of banned words which I have named "content_check" and are in a tab called "Guide". I want to make a macro which will check cells G13, G...

[Solved] Refer to a Range on an External Closed Worksheet (VBA)
Summary: Hello, In my code instead of referring to a sheet internally, I need to refer to a sheet externally which is also, preferably, closed. I was wondering...

[Solved] Excel Macro to Save File Named in Specific Cell
Summary: I have an Excel 2013 spreadsheet that develops hyperlinks for the user to click on to view certain files. However, I want to be able to give the user ...

[Solved] missing: :-) VideoSoft vsFlex3 Controls in references
Summary: One day my excel macro button quit working and we traced it back to the above mentioned missing control in references. The smiley face is there too. ...

[Solved] Excel search box and copy all results to sheet # 2
Summary: Good day.. I've searched for an Excel macro that does the following : 1. Press a button to open a search box 2. All results found to be copied to shee...

[Solved] Excel macro to delete row
Summary: Hello all, I know little to nothing about Excel macros. Here's what I want to do: If column A contains a date then delete the entire row where column ...

Need an Excel Macro to autogenerate records.
Summary: I am preparing a data generator tool by using excel macro. I want to design a macro which wil ask user how many records you want to generate? after us...

[Solved] Changing Printout in Loop
Summary: Hello everyone, The below codes prints the column 'A' competely & then shifts to Column 'B' instead of that is it possible to shift alternate after ev...

[Solved] Excel Macro to copy user specified data to new worksheet
Summary: I am trying to create a macro that searches for a range of dates by prompting the user for a start and end date and then searches a specific column by...

[Solved] Excel Macro to create new worksheet in Excel 2010
Summary: With due respect and credit to DerbyDad03 whose earlier post gave me the code below; is there any way to have the new worksheets created from a variab...

[Solved] Excel Macro to create worksheets from list with hyperlinks
Summary: Hi I am using this code below to create Excel sheets based off of a range of cells from a main sheet. I would like to do everything below but in addit...

need to segregate data based upon two columns
Summary: Hi All, I am working on a file which needs to be copied and pasted into respective tabs based upon the name. For eg: in the below tablei have few colu...

[Solved] excel- need to cut data every 12 columns & paste as new row
Summary: Hi experts! I have 0 experience with macros but i suspect that's the best solution for what i need. I use excel 2010 and i have a data sheet with num...

An Excel Macro to find only the exact wordn & copy rows base
Summary: An Excel Macro to find only the exact wordn & copy rows based on a keyword list I am using the below script Sub carHunter() 'Determine last row with d...

How to create a macro to sort data to new tabs in excel
Summary: I am trying to recreate a macro I had on my old computer (written by someone I used to work with). The macro was made to run on a large excel spreadsh...

Use a Excel macro to move data to uniquely named tabs
Summary: Hi I have to move a list of people that have a unique number to a new tab. See example: PQR FullName UsName Description two ...

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...

move multiple data out of one cell
Summary: Looking for an excel macro that can solve my problem i have multiple numbers in one cell separated by spaces that i would like to move each out to the...

Excel Macro to unhide specific hidden tabs
Summary: I need to make a button to unhide a specific number of tabs. Example I have tabs named Guarantor 1 thru Guarantor 10. Is there anyway to assign a ma...

[Solved] how to run a excel macro using batch script or vba script?
Summary: how to run a excel macro using batch script or vba script? ...

Excel Macro to create new individual worksheet on ID
Summary: I am new to VBA macro programming, so i have been doing trial and error from code that was placed on here earlier that was very similar to what i am t...

[Solved] Replace single keyword with list of keywords making copies
Summary: I have a keyword list in one coloumn and I want to replace a single keyword with the list of keywords separately to make a different versions of same...

12


Ask Question