The discussions
Vba inserting row and keep range membership
SolvedIn VBA, how do I copy/insert (in place) a row and ensure that if the source row intersected a column range, that the new row would also be in the rang...
I need to get a sum from multiple 'if' cells
SolvedI have a spreadsheet with the following formula: =IF(ISNUMBER(E5), "20.00","") If data is entered in cell E5, the cell below it will have 20.00....
Match with conditional format in excel 2003
SolvedHello Internet, I am in a bind here as I have exhausted my excel knowledge on this problem. I am looking for a way to highlight (in red) a cell wh...
Excel 2007: reading data from sheet to sheet
SolvedI am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting ...
Excel vlookup macro
SolvedHello, I am working on a project to create a simple VLOOKUP. I have created the macro and it works well, but now I am looking for some advise on ...
Interesting question for excel champions
SolvedHello, Interesting Question Guys: Suppose Sheet 1 Is "Data" Sheet And There Are Too Many Rows... Like A3 Is S.No B3 Is Supplier Name C3 I...
Coping rank for whole dataset in excel
SolvedHi i want to work out the ranks for my whole data set, if i type in the formula for the first line then drag it for the rest instead of working out ...
Automation of running excel macros
SolvedHello, I have a macro in excel which needs to be run once a day and i dont even want to open the excel sheet. How can i make this process automatic...
How to align all common list in excel?
Solvedi have 4 columns. the first two (A & B) columns are list of cheques i issued. then the other two (C & D) columns are list of cheques encashed from Ban...
Coping cells with a loop
SolvedHello, I am stumped on what should be a very simple macro. I am running a macro that is using a look-up table to compare the values in column G. ...
Help on excel formula
SolvedI need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...
Identify two or more are same or not in excel
SolvedHi Everyone, I have an excel formula question that someone might can help me with. A B 1
Merge rows of similar data
SolvedHi, I am trying to merge various rows of data with a common headin in Column A. For example I have the following data: A 1 0 0 0 1 B 1 1 0 0 ...
Excel pro
Solvedhi , i have some data like gvn below M/C SR NO. total b4 a4 cl4 k92661400 18632 8544 544 9544 K81667500 21844 18948 1948 948 H25102020 6756 8...
Filter duplicate entry with condition w excel
SolvedHi, I've 2 columns of data. Column A are repeated Test sequence and Column B are Status (OK / Fail). I would like to extract those test sequence wi...
Find max valu every 10 rows &mark row as keep
SolvedHi, I need help creating a formula in excel to Identify the Highest and Lowest values Every 10 rows THEN Identify those two rows...
Compare numbers in two columns in excel
SolvedI appreciate any response to help me with this. I have two columns of numbers A B B.121 S.222 S.154 B.121 B.164 ...
Excel macro - using integers as cell referenc
SolvedOK, I've written this and I'm having some trouble. I've put the comments in the code (preceded by ****) rather than giving you a summary here. I thi...
Excel: need macro to run when value entered
SolvedHi! It's been a long time since I used VB. I seem to be a bit rusty, and I can't figure this out. What I need is for a specific macro to run when...
Macro to deleting multiple rows
SolvedHello, I am running a simple formula in excel to sort out duplicates from a given row, by adding the value "DUP" in a new column on the spreadsheet. ...
Extracting data from specified columns
SolvedI have some columns of data looking somewhat like this: data1...data2...data3 val.........val........val val.........val........val val............
Need help on an excel if/then in macro
SolvedI'm trying to create an If/Then in Macro for a cell which you input what GPM you want to use. The goal is to stop sales people from making errors and ...
Copy down formula if cells on left non blank
SolvedHi, I need code to copy down a formula from R2 to R3, R4 , R5 etc only if H3, H4, H5 etc is nonblank. I also need to copy formulae from U2:CY2...
Compare two columns and delete duplicates
SolvedI have a large amount of data that is supposed to be unique based on two columns (Column A, Column B). The combination of these two columns are not s...
Compare 3 columns excel
SolvedHello, I have to compare 3 columns (A,B AND C) filled with names and return, in another column (E), the list adding the names from the 3 columns (...
Excel macro to group by column & sum value
SolvedHi there, I need to write a macro for following example. Item Qty Length A 1 100 A 1 100 B 2 200 B 1 100 B 5 100 C 4 200 C 2 100 C...
Adding cells
SolvedHello, I am trying to build a macro that allows me to input a number on Sheet1 and then on Sheet2, add that number of Cells. Example. Sheet1 ...
Help with excel percentages
SolvedHello, Please bear with me as I a very new to this type of syntax with that said here we go. I have four date columns in Excel like so: P...
Assign macro to all yellow highlighted cells
SolvedHello, I am in currently in a pickle ... I hope all the masters could lend a hand to this VBA noob... Right now i wrote a macro to copy all formula ...
Excel vba msg box when cell meets criteria
SolvedHello, Hi this will probably be very simple for someome however I am having a nightmare day, all I want is a vba formual which will bring up a mess...
Excel page linking
SolvedHello, I'm trying to link 5 pages which each have a total amount on, I am looking to put all the totals automatically on one page, what i am asking i...
How to make formula in excel cell for time?
SolvedHello, I want to make spread sheet with time in the Excel CELL How to do that? For example 1st cell should show 11hrs.56mins.05sec and next cell I ...
Marco to delete cells containing an interger
SolvedHello, I am stuck and would love some help. I have two Columns in Excel J and K. The two Columns contain numbers from 1 to 53. I would like to...
Excel
SolvedHello, I have an excel file with Start dates, end dates, total day, and networkdays columns. I would like to average these number for the average to...
Problem with "lastline" in vba excel 200
SolvedHello, Let me start off by saying that I'm a VBA noob, and have never worked in it before. Basically, I inherited a spreadsheet which has a macro t...
Macro to delete created object
SolvedHello, With the following VB code I have created a wordart object: Sub ShowMessage() ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, "Even...
Delete certain cells of active row
SolvedHello, I would like a code for the following: Check which row is active/selected and then delete the data which is in the 5th and 7th column of ...
Insert rows based on count of row in another
SolvedHello, I have a excel where I create few dummy accounts and the next sheet (sheet2) has details of these accounts. I need the sheet 2 to have certai...
Excel macro - dynamic column selection
SolvedHello, I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column ...
Excel conditional formatting row color
SolvedHello, I am trying to get Excel to automatically change the color of a row depending on the entry in column H. I've got some VBA code written up, but...
Copy data one sheet to another
SolvedHello, dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data da...
Macro to compare two sheet with both sheets h
SolvedHello, I have a 2 excel sheet which has all the column having same. This has D$C Comment, OMS comments, Planned Resoluiton date & Sub account in bo...
Lookup,count and pie chart excel2007
SolvedHello, Can anyone give advice? I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 ...
How to fill selected cells with given data?
SolvedHello, I often need to fill cells with a date of production. What kind of a macro would be usefull in this situation so that I could just select the...
Find a string in excel and remove all cells
SolvedHello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions...
Cut-paste row to sheet2 if columnvalue is met
SolvedHello, I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains comp...
Excel help
SolvedHello, I am having trouble with an excel calculation, i'd be grateful for any help: I have menu items listed along the top, with a space for th...
Getting perfomance of each vendor using excel
SolvedHello, What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity...
Excel forumla help (if formula)
SolvedHello, I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grad...
Excel macro loop to insert pics into more cel
SolvedHello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
