Vba Related Problems & Solutions

77 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 77
[Solved] VBA to Insert LastRow into a Formula to count Unique Values
Summary: I am using VBA to insert a formula which will count the unique values in a previously selected column. The formula is inserted in a cell of my choosin...

[Solved] Does anyone know where All Experts went?
Summary: All Experts was a great site and one of their Excel experts, Thomas Ogilvey, was incredible at vba and macros. I asked him so many questions and he w...

[Solved] VBA to Move String in Cells from End to Beginning
Summary: Hello, I have some values that represent a decrease of inventory and when pasting them in excel they come in the following form: 50- 140- etc. I made ...

[Solved] VBA to Generate Multiple Shapes Based on Number in Cell
Summary: Hello, I made a macro to create rectangles based on cell values for a 2D excel simulation. The code below adds the shapes once per each line I have in...

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 insert a formula in a column
Summary: Hello, Me again. I've been struggling today trying to make a macro to insert an INDEX-MATCH formula in a column (since I can't seem to make it work ot...

[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] (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] VBA copy a coumn contains certain charactor
Summary: Hello there.. Can I use VBA to copy column A to column B or C as below? Basically if it contains T511 it will copy to column B and if it contains PILC...

[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] Insert rows based on column count
Summary: I have data that I would like to write vba code to reformat. Specifically, I need to copy and transpose column data into rows. However, I do not want ...

[Solved] VBA Code for SavingAs excel sheet without Message box!
Summary: Hi, I am trying to saveAs a macro-enabled workbook to xlsx format. The problem is every time excel shows warning message when the macro button is clic...

[Solved] Can you maintain blank rows with a vba auto filter?
Summary: I have a worksheet with data that is automatically filtered when a date is entered in cell I1 via a Worksheet_Change(ByVal Target As Range) macro. Row...

VBA to AD - error after 1000 users
Summary: I am currently working on a project to query AD , I have a script that do that, but the script is failing after 1000 users , while the users I am quer...

[Solved] How to add $ sign automatically in the formula in MS Excel
Summary: Hi, I have an excel worksheet containing column A to M with data from row 2 onwards. E.g. For row 2, value in M2=K2+L2 and row3, value in M3=$M$2 For...

[Solved] Check & set the start date after another task end in excel
Summary: I have a schedule control Excel sheet, such as below Item Task Start End "predecessor task" 1 Gather requirement 2016/5/3 ...

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

[Solved] Vba CodeCopy certain value of cell from column
Summary: Hi I am having difficulty to right vba a code which is below there is a huge data set in column C:C of which i have to work with 165 values which come...

[Solved] How to match value in separate sheets and copy/past the row?
Summary: Hello everybody, So basically the situation: In the sheet1 (master reports) column A i have code such as AAA-12122 and then all details in the other ...

[Solved] VBA code to insert new row and copy from row above
Summary: Hi, I have 100 groups of data. Group1: 10 rows of data in row 2 to 11 from ColA to G. Cell A2 to G11 have been filled up. Group2: 25 rows of data in r...

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

[Solved] Result of formula to comment
Summary: Hello all I have some pretty big text strings in a lot of cells and I am on the edge of losing the big picture. I have searched for a solution and wha...

Copy/delete rows based on group numbers
Summary: Hello all I have a worksheet that looks like this example worksheet I have made: http://www.filedropper.com/examples... For sheet1 I need some code th...

[Solved] Copy/delete rows based on user input
Summary: Hello all At work we have a big issue that I have got to sort out and I hope some friendly person on this nice forum would like to help me with that. ...

[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] 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] Combining information from one master and 11 user workbooks
Summary: Ideally I'd love vba script for this and am working on that option but need some assistance. I have two people that log in new cases to a workbook bu...

123


Ask Question