Excel Forum

Filter duplicate entry with condition w excel

Solved

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

If statement for data in columns

Hi im a little stuck I have 2 columns of data, i want to get the value of column 2 by searching data in the entire column 1. If column 1 matched w...

Special sort in excel

I want to make a results sheet in excel for a competition that will create an automatically sorted list so that it can be quickly and easily uploaded ...

How to write excel macro to auto sorting

hi expert, may i know how to write excel macro program to perform auto sorting of rows of data and then auto create new files for only each set of ...

400+ worksheet loop macro

First off, thanks Rizvisa for your help previously creating a sucessful macro to loop through all open worksheets in the active workbook. It works pe...

Find max valu every 10 rows &mark row as keep

Solved

Hi, I need help creating a formula in excel to Identify the Highest and Lowest values Every 10 rows THEN Identify those two rows...

Excel, if statement with part of text matchin

Hi, I would like to find out an if function or VBA code that will return a certain number if parts of a cell contains the text that I'm looking for...

Macro or vba code to found and paste

i have two files, one is excel which contains few articles like 111230, 111412, 552136 etc and other file is notepad which contains hundreds of articl...

Selecting rows in excel

Hi, Column A has several numbers ranging from single digit to seven digit ones. I am only looking for rows which have 4 digits numbers. These rows ha...

Compare numbers in two columns in excel

Solved

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

Delete row if 2 cells match in excel

Hi, I tried to use this in as a Excel macro and it removes the wrong data from sheet (Org). Can someone tell me what is wrong with it? Column D ...

Mark duplicate rows in excel 07

Hello all I am looking for a macro that can help me mark duplicate rows in excel eg col A col B col C Result of macro 1 a m 2 b n 3 c s ...

Macro to filter dates.

Hi All Could someon ehelp me with a macro to filter dates. I have in place a form created to store the start date and end date onto two cells. All...

Excel macro to select and copy

Hi, I would like to how the code to write a macro that can select/copy the last entry in a column/s. Thanks in advance PM Configuration: W...

Compare two columns and calculate sum

Hi, I have a table in one sheet and a column in another sheet something like as shown below Table in Sheet 1 ---------------------- Region1 ...

Excel macro - using integers as cell referenc

Solved

OK, 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

Solved

Hi! 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 paste range into all other sheets

I know this should be much easier than I'm making it. I'm simply tring to loop through all existing sheets in one workbook and paste a section from a...

Macro to deleting multiple rows

Solved

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

Excel -viewer select cells for sum

Help, What I need appears basic but browsing through other questions I don't see it asked/answered. I'm organizing contractor's bids on projects. ...

data from html to excel in linux

Hello I've a shell script which generates a html file in each iteration.I want to get 3 values from the html file to be merged in one xcel file seque...

Creating a macro for displaying a pop up box

Hi, I've created a spreadsheet for keeping a selection of data. Once a cell reaches the number 10 I'd like a pop up box to appear saying "Jon now ...

How to add number of sheets in workbook

Hi all, How i can add number of sheets using macro. For Example. i have assing A2 as a sheet count for addition how can i accomplish it. m...

Excel unique filters

Hello, I need to filter unique values from 2 columns and place those value in a third one.. can any one help me

Copying output in excel

Hi, I have written a single cell formula in Excel which gives "Pension Amount" depending upon the inputs on "Age" and "Salary" of the pensioner from a...

Excel macro to lookup cell and add new row

Hi, I want to create a macro which will look at for example column A and find the last number entered then add a row below it and to do this every ...

How to create macro to search and copy

Hello, I have a spreadsheet with all different dates with corresponding data in its row. There are many rows with the same date and i want to create ...

Themes for my browser

What is the best firefox browser that i can use for my pc?

Excel macro to filer by date and find dupes

Hello, i need a macro to be created in excel to first filter the data by latest or the last date in the end time column and delete rest of the data,t...

Moving data within spreadsheet

Hello, I am copying data from another system to an excel spreadsheet. I need to create a pivot table in the end. Data is very busy and when I Text t...

Remove alternate rows

I have tried doing it with the use of a macro but it is not working. Does anyone know how to do it?

Extracting data from specified columns

Solved

I have some columns of data looking somewhat like this: data1...data2...data3 val.........val........val val.........val........val val............

Combine 2 rows into 1 row, over and over

I have over 5,000 rows of items I need combined, but they need to be combined in a certain way. Below is an example of the information I have, all in ...

Excel problem

I have never used excel before but I have a long list of names for business transactions. how will i be able to count the list of names wityhout wasti...

Need help on an excel if/then in macro

Solved

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

Macro

I would like to write a macro that will insert a certain name into a cell depending on what number is in the cell beside it. There are about 20 differ...

Counting in excel

Hi I have an excel spreadsheet that has totals in 4 different tabs. I have a final tab that sums up the scores of the 4 tabs. A B ...

Copy down formula if cells on left non blank

Solved

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

Help please! excel sos

Dear Experts, I have a data here on excel Column A with the following arrangement 1 Radio Link south 2 Capacity ...

Excel 2007 - deleting multiple rows

Hi - I'm hoping for some help in deleting rows in a worksheet. I have data that is imported from a database into Excel. I want to: 1) Delete rows...

Urgent vba excel help! - reorganize data

Hello, How do I write the VBA code to search Events by date and reorganize them into a totally different format in a different sheet? Original spr...

Excel functions

Hi, Good day! Can someone tell me formula to find the datas which range's between 1 - 5, 5 -10, 10-15 and so on till 95-100 in a column and mu...

Macros help

Hello, I am trying to write a macros that will help me delete the first three characters in a cell. I copy and paste a set of serial numbers into an ...

Match phone numbers on excel sheet to address

Hello, One Excel sheet #1, I have names and addresses of a very select group of about 5,000 people. Address is in column H. On Sheet #2, I have...

Excel if formula help requesr

Hello, i am entering my formula like " =IF(H5=AMC,"=M5*5%") " but i am gating error like #NAME, can any body help me to calculate 5% value of my M5 a...

Only run a option button macro if a cell >0

Can anyone help with adding a limitation to a macro? I currently have a very simple option button activating another worksheet in the workbook. But I...

Compare two columns and delete duplicates

Solved

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

Automate simultaneous entry of data in cells

Hello, I need to format two Excel cells on the same sheet so that when data is entered into one, the same data automatically is entered or copied in...

Excel cell reference; '=+' meaning

Hello friends here, I wish to ask a question about Excel cell referencing cell value from another work sheet. 1. The value in the cell was like ...

Excell formula

Hello, I want to add an alphabatic letter in percentage formula in excell sheet. plz write me how can i do it.

Subscribe To Our Newsletter!