Macro Related Problems & Solutions

118 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 118
Using VBA/Macro for data entry
Summary: Hi there, hoping someone could help me out with this. I am currently working on a project that seeks to find out the most popular content posted on s...

[Solved] Macro to display message box once for each cell
Summary: Hello, In an excel file with various columns, I have a formula somewhere in column V that calculates a percentage. If this percentage is over 3% (...

[Solved] Macro to memorize dates in a column
Summary: Hello, Assuming I have an excel file in which I want to complete a year's deliveries that are made on a daily basis. I will take a simple example: - a...

[Solved] Macro to remove some text with condition and add color shade
Summary: Hello, So I made a macro to format a table. I will post the macro below and there are comments that explain things. Here's how my table looks like: ht...

[Solved] How to edit an excel email macro to send only 1 email?
Summary: Hello, I got a macro online for sending emails given a condition. It works great if you have 1-2 entries that require email sending based on the cond...

[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] Auto-insert new row on different worksheet on condition
Summary: Hi, I have a question very similar to another question that was answered in a thread on this site around a year ago. I found that thread very helpful...

Macro help to pull company each time it's added to list?
Summary: I hope someone can help with this, it's been about a year since I've worked with Excel and I cannot wrap my head around this! We're trying to track ho...

[Solved] How to Extract Email Addresses From Excel Spreadsheet
Summary: How to Extract Email Addresses From Excel Spreadsheet. How to extract emails from different cells into a new sheet. ...

[Solved] VBA code to copy cells to X-number of rows lower for X-times
Summary: Hello all Can anyone help me with this Little VBA script: I need to be able to select a cell, then run the macro and that macro will then copy the cel...

Search and replace macro
Summary: Hello all Does anyone have a macro for Excel that can do the following: I have some text strings in column A like this: ";B" and "(B" and "BV" and so ...

[Solved] Can't change variable within Access 2003 macro
Summary: I have an Access 2003 report that I need to export, to separate files for separate recipients. Currently, I do this by having separate copies of the r...

[Solved] VLOOKUP for matches on two ws and carrying data
Summary: VLOOKUP might not be the right choice here but I'm trying to find corresponding data on two worksheets in the same workbook. Sheet 1 is a report that...

[Solved] Replace a worksheet with one from another workbook
Summary: I have a wb with 11 worksheets and each ws has multiple formulas. The first worksheet is called 'Raw Data' which the users put their data in and the o...

copy and paste to a column I if column H is not blank
Summary: Hi, I'm making some macros for a report of mine, and I am stock in this... need an example to copy from a cell in a workbooks calls "X", sheets1 and ...

generate list depands on item selected in dropdown list
Summary: Hi Team, I have to create employee list depands on manager name selected in drop down list. Please help me to solve this issue Thanks ...

Need Macro to find number which prefixed 0
Summary: Hi Team, I have to update data in an application. And the application accepts only 2000 characters to update. So I need to compress the data. I can’...

[Solved] Using a macro to update a waterfall chart
Summary: I have a spreadsheet that I want to automate updating. I recieve a report (in excel format) that contains update data daily. I want to make a macro th...

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

Macro to edit cell depend on next cell
Summary: Hi Everybody, I have a question. I need to update status in A1 cell if B1 cell value is TRUE. Else massage box should popup that details not updated p...

Copy Multiple values from Drop list to single cell
Summary: Hello all, I am trying to find a way to have all selected values from a drop list (with multiple values selected) to also displayed/copied in a cell (...

[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] Macro for changing Tab Colors in Excel
Summary: I was hoping someone can help me with a Macro. I have an Excel Spreadsheet that has numerous tabs. Some tabs are different colors. I was hoping fo...

Change Key commands - which software to use?
Summary: I have a Compac Presario, I'd like to change the function of keys such as Print screen, Windows Help etc. I can't do this with normal Macro software,...

Macro To Copy Random Rows
Summary: I need a Macro To Copy Random Rows from one sheet to another. A post by DerbyDad03 was giving the answer but I don't understand how to make it work i...

Excel Macro to find data that fits Patterns?
Summary: Hello. I'm facing the following problem: Every day I have about 56 Excel files where the filenames fit the following 2 patterns: - half of them are n...

Search an Excel Workbook 4 Multiple Criteria
Summary: I am looking for how to write a macro for a search of up to 11 different cells that would contain criteria of what the search would return for results...

[Solved] Channging Font Color of entire workbook
Summary: Can someone help me create a macro or tell me how to accomplish the following? I would like the macro to search the entire Microsoft Excel workbook f...

[Solved] Channging Font Color of replaced text
Summary: The script that DerbyDad03 provided for my last question was awesome. THANK YOU....But now I'm looking to do a little bit extra... Can someone help me...

1234


Ask Question