The discussions
Delete duplicate items in excel
Hello, I need to write a macro where it deletes duplicates but the marcos out there seem to delete all duplicates I just want it to delete a cell i...
Can not run macro
Solvedhello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...
How to create shortcut keys to xl 2007macros
SolvedHi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...
Ignoring rows with zero value
SolvedHello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...
Excel delete blanks help
Hello, I have a macro to delete rows where if the cell in column c is blank as follows: Columns("C:C").Select Selection.SpecialCells(xlC...
Highlighting the values entered in an excel
SolvedHello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...
Copying data to another worksheet
SolvedHello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...
Excel: matching and sorting
Solved/ClosedHello, Ok, how sould a computer dummy to this (the dummy is me): I have a list of 300 bike racers. In the columns next to the racer is items such a...
Inputing selling price into excel
Hello, I have a list of table in my excel as below: Stock Code Supplier Description Selling Price 3MAY018 NIEHA DRESS 3MAY01...
Sum data value of different sheet of excel
Hello, I want to found some formula for summing different sheet. My problem is like this. I am one excel worksheet, there are different 12 sheet...
Can someone please write me a macro for excel
SolvedI want to be able to input a number into a cell and have that number recorded in a list elsewhere within the same sheet. Then be able to replace tha...
How to find a cell in a macro..
Hello, I am creating a macro and what i want to to do is to find the word "Tylenol" and then go to the cell beside it and i want to put a formul...
Excel
Hello, I have created a calendar in excel, it can update automatically once the year is entered. I have another sheet "Customers" with "customers li...
Excel help required
Hi, Basically I have a document that is 30,000 lines long showing data in 1 second intervals. I would like to delete all the data so that I have in...
Excel tips needed
Hello, I have salary sheet for different months for different workers. Some of them are not in one month and another new worker are add in new mon...
To set 4 pagebreaks by vba in worksheet
Dears, I would be very grateful If someone can help me. I have several sheets in one excel file. I need one command button when pressed to set 4...
Copy selected cells to new sheet in a row
SolvedHello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f 32, ...
Formatting date in excel sheet
Hello, I am working in SAP wher i generate a report which download in excel sheet in dd.mm.yyyy format but i need convert it to mm/dd/yyyy format ...
Vba-conditionally selecting and copying data
ClosedHello, I have a file with 5 columns. one with date, time, latitude, longitude and amplitude. I need to conditionally select data from the latitud...
How to copy data from one sheet to another
Hello, I am having a workbook. In sheet 1,m having store name in column A(A2:A9),in column B inventory for soap ranging B2:B9,in column C inventory...
Internet connected but can't browse
ClosedHello, today I saw the 3g modem HUAWEI is connected, antivirus can update database but I can't browse the internet. I trid to delete Uniblue PowerSu...
Conditional copy and paste using macro
Hello, Just want to seek help to anyone about my problem about copying and paste multiple cells from sheet 1 to new sheet hru new sheet also with ...
Match up names in excel or access
ClosedHello, I have a list in excel of of car types in column A and the owners in column B. A lot of owners have multiple cars of the same type making a...
Generating reports using macro in excel2003
Hello, Hello I have a task to be done once on every month-end. I am working in a private bank. I have a file called BaseFile. I need to generate re...
Is there a way to delete all dates in excel
Hello, Is there a way to delete all dates in an excel workbook without deleting the actual cell they are in? For example, I have some cells that s...
Reading an excel and filter data and add.
Hello, I have an excel say Book1.xls. I will have data with 10 columns and 10 rows in it. I will have another sheet in the same excel. I will ha...
Macros help
SolvedDear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...
Transfering data to a new sheet
SolvedI'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...
Format data in excel for db transaction
SolvedHello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...
Create macro replace blank cells with counta
Hello, I want to create a macro that will find a blank cell with Counta value of > 0 and delete that entire rows. Configuration: Windows XP / I...
Excel macro to copy text and append
SolvedHello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem...
Using conditional formatting in excel to high
Hello, I want to highlight the row based on cell value. For example. If I put 10 in one cell, it should highlight 10 rows like that. please advise...
Cell reference to locate /store data in excel
SolvedHello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...
Copy row in excel to specific tabs
Hello, I'm not very smart once I get outside of if-then formatting. I have an excel worksheet. It is used to track purchases for different divi...
Excel equation
Dear sir, I shall be much obliged if u solve this equation using excel formula is E = P×r×(1 + r)n/((1 + r)n - 1) (here n is power plz dont read i...
Average above "n" rows in blank row
Hello, I'm working on a dataset of historical price data. The set has dates in column A, and prices in column B. Through a macro I have inserted a...
Copying data from one sheet to another
Hello, Macro newbie here. I'm trying to copy 351 rows of data from one sheet and paste the data to every 14th line on another sheet. Help! DR ...
If statements in excel
Hello, I'm looking for some help with conditional coding in excel. If text is entered in one of eight specified cells, then I would like 1 added t...
If statement in excel looking for text
I have a column with 3 text labels (book, pencil, eraser). I want to create a new column where I can find cells in the original column that have eith...
Excel macro help
SolvedHi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...
2 sheets compare for differences
Hello, I have excel workbook with sheet1, sheet2 that have same data in column A. I need to find the difference in the 2 sheets. The records tha...
Roman number series (macro)
Hey guys. I need to make macro witch makes series of Roman numbers (Similar to built in excel series- http://i63.photobucket.com/albums/h129/Edds87/...
Macro for printing in ms excel 2007
Hello, I have standardized reports that I create in MS Excel 2007 on a daily basis which must be printed under certain parameters. How do I creat...
Excel date format
Hello, In the Excel sheet I have dates are in the format dd/mm/yyyy. How do I format it to be yyyymmdd ? . Your quick responce will be much ...
Delete allowediteranges by vba
SolvedDear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...
Delete allowediterange by vba command
SolvedDear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...
Excel conditional formatting rows to columns
SolvedHello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...
Help about macro copy and paste
SolvedHello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...
Copy to first open cell in rowb/sheet 2
SolvedHello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...
Excel time clock spreadsheet
Hello, Can somone please try to help me? I have a Finger Print Time Clock. I am exporting the data into Excel, that looks like the first to rows, i am...
