Excel Forum

Excel- count unique entry in different groups

Hello, I can't figure out how to write a formula to count unique entries in different groups. My goal is to have a non-excel user to just paste ...

Copy multiple sheets to another sheet vba

Hello, I want to copy data from Multiple Sheets to Another sheet is there and VBA available for it Thanks and regards, M.P.Mani

In excel the value of date of bitrth changes

Configuration: Windows XP / Firefox 3.6.2in excel the value of date of birth changes, into numeric number. mostly that time when it paste them on any ...

Compare two columns and delete cells

I have 3 columns in Excel 2007. The following is the sample data. Col3 is a formula that compares Col1 and Col2. If the value in the two columns ma...

Macro not copying correct data

hi m trying to copy column D from one tab and pasting it in another tab. When i luk into code it shows copying (D:D) but it selects columns A-D and pa...

Excel 2007 - look up a cell in a tab

Within tab 1 I have a cell with an entry of Road 1. In the next cell I wish to go to the Road 1 tab and copy the contents of a cell. The entry Roa...

Using excel if function with data validation

Closed

Hello, i am running EXCEL 2007. i am trying to make an if statement that accomplishes something like, If c1=b1 then d1 = pick a choice from the ...

Date time picker control excel

Hello, i have a user form with a date and time picker control on it. user selects a date and an update action updates a worksheet (called table) wi...

Merge rows of similar data

Solved

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

Solved

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

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

Excel Forum

Subscribe To Our Newsletter!