The discussions
Transfer data to match on excel
I have two reports. One is from 2010, the other is from 2011. Within each report is the same information...account numbers, member names, credit sco...
Paste to all sheets except some with criteria
SolvedHi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...
Formating a column using macro
SolvedSir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...
Excel vba user form
Hello, I am quite new to Excel VBA and I , desperately, need an expert help. am trying to create a user form that generates customer IDs made of 9 ...
Call an excel document to another sheet
Hello, Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet. For Example Book 1 got he...
Automatically copy from one page to excel
Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...
Excell conditional formatting
Hello, I have been using conditional formatting to make a cell change colors if a)greater than or b)less than, today's date; however, I don't know...
Office 2010 excel
SolvedHello, i am trying to show in cell J2 if the sum of cell I2 is more than 10 to show 10 and if the sum is les than 5 to show 0 have found how to show ...
Excel 2010 - if function with dates
Hello, I am trying to show in cell J2 if the date of cell I2 is between 1/1/2011 (MM/DD/YYYY) and 12/31/2011 to show SS12 and if not between those ...
Create new worksheet with data
Hello, i have created a workbook, that contains my home income and expenditures. it contain for every month, i want, it create a new worksheet for...
When data changes in sheet1 delete row in s2
Ok, I was able to use Macro to copy row from sheet 1 to sheet 2 with a condition. Now i want to either add to the Macro or create another Macro to de...
Data transfer between cells
HELPPP meee!!! :( 1. i desperately need to transfer data between cells within a single EXCEL sheet. 2. on top of that, i need to have the data m...
Copying data from worksheet 1 to worksheet 2
SolvedHello, I am using MS Office Excel 2007 and need to know how to copy a row of data from one worksheet to another worksheet using a criteria from colum...
Copy rows based on criteria - vba
Hi I have about 25000 entries of data that I wish to sort, Angle and time. I want to take them from a complete list in Sheet A to breakdown in Shee...
Multiple conditions multiple worksheets vba
Hello, I've a small macro which I cannot get working. I would like the macro to copy from sheet 1 anything that has the country code 'ITA' and is ...
Excel - delete info from a cell found in anot
SolvedHello, Hello, I need a solution for the following situation: See attached screenshot from my Excel spreadsheet. I would like to know if the...
Cut &past data from sheet to shhet depending
SolvedDears, I'm a novice in M* Excel. Still, for day to day followup purpose, I need a macro and/or appropriate solution that does the following: For...
Need some help comparing rows from 2 tables
Hello, i have 2 tables... table 1 has sequential serial #s (a) and corresponding prices (b). table 2 has the same serial numbers (a) (used multi...
Find and display match text between columns
Hello, I have a work sheet listing Client names in column A and IP for each client in column B. Column C has a list of IPs which I need to match ...
Excel help?
Hello, I have a pivot table that lists items I sell at auction. After the auction ends I need to produce invoices to all buyers and I want to wri...
How to do html tagging in excel
Hello, Guys pls do help me i have one sheet with lots of details in it and for eg in row 1 from cell A1 to A100 has different content but i need t...
Deleting rows with negative numbers
Hello, I would like to delete spreasheet rows if column H contains a negative number and the line above it in excel. Please help! Configuration...
Convert multiple rows and columns to one colu
SolvedHello, I have some data in excel sheet. Here is the example. 480,000 600,000 720,000 520,000 650,000 780,000 300,000 375,...
Excel formula
Hello, I want to set up a formula to send information from one sheet to another in the same workbook. The information in the source worksheet is...
2010 excel cell color changing
Hello, I have a spread sheet that has due dates, I want to change color of cells to reflect time due eg: time of due date red 5 days before due...
Color code excel cells according to scores
SolvedHello, How do I color code cells in excel ti turn colors according to scores--such as red (0-69%), yellow 70-89%), green 90-100%)? Thank you, E....
Match excel columns containing names
ClosedHello, Using Excel 2010 and I have 2 lists - 1 from phpmyadmin with a list of names entered by my users and a second list from my courier company ...
Updating 1 excel spread sheet usng 2nd sheet?
ClosedHello, I have 2 excell spread sheets, bothare mailing lists. i woould like to match firstand/or last names from the 2 lists inorder to be able to u...
Can i delete text up to a character in excel
SolvedHello, Is there a way of deleting all the text up to a certain character in excel. i im trying to import a CSV file in to exchange and need it tyding...
Excel - fill column in list based on criteria
Hello, I am trying to fill a column in a list, based on criteria. Example: In Table 1, I configure the criteria: If string contais "aaa" ...
Excel: match data/copy to another worksheet
Hello, Can someone help me with this please? : ) I'm using 2 worksheets: On 'Tab A' I have: Column A Column B Notification Product Even...
Excel-macro to group by column & sum value
SolvedI was searching your web site for an example of how to group two columns and sum two different columns. I found an example under the question "Excel ...
Excel macro question
Hi, I was wondering if anyone can help with a macro that would search for a value entered in a dialog box within a number of worksheets and then p...
Compare two excel sheet
Hello, i want to compare two excel sheets if the row in second sheet is not there in the first sheet i need to copy that row from second sheet...
Need support vba stuff on excel
Hello, I am nani and i have no experince in VBA scripting now i wanna phase out my self to learn Macros VBA with Excel as my most of the day work ...
Data replication using macro
SolvedHello Experts, I have a requirement as follows: User data Entry: Column1 Column2 Column3 Colulmn4 TIME JAN FEB MAR INDIA Bangal...
Excell help needed
Hello, I have next problem in Excell, I have columns A1, B1, and C1 with data like this: A1 B1 C1 ABCDEF 4444 ...
Pop up vb in excel 2010
Hey guys, I have a large excel file with tons of information about my employees. I need a way to have a pop up to remind 3 months in advanced for w...
If statement help excel 2010
Hello, This forum seems very helpful... I'm working on a spread sheet and have run into a wall with a specific IF statement. I want the cells i...
C+p macro to dest. based on value
Hello, I'm still learning Macros and the like, and have had some luck learning the functions for what I have need in the past. What I am tryi...
Not able to hear sound from any browser...
Hello, I am working on 64 bit computer.IE 9 windows 7 . The procedure said did not work fine. "It says the specified file is not a registry file...
Create a list based on input cells.
Hello, I am trying to create a vertical list based on cell in sheet2 with various data in sheet1 example file is saved in : http://www.editgr...
Going from one excel spreadsheet into others
ClosedHi everyone, Another newbie here. I have one main excel spreadsheet and I need a macro that looks in a specific folder with 48 individual excel...
Excel 2007 data from many spreadsheets to one
Hello, I'm trying to make a compilation spreadsheet inside a workbook (Excel 2007). We have data from 83 different facilities that each have ...
Problem with excel vlookup table array
Hello, I did a vlookup which worked well however, when I opened the spreadsheet and it asked me if I wanted to update, of course I clicked yes. ...
Excel: if date changes
Hello, Here's what I want to do. I have a Column where I change the date and I want certain cells in this column to extract different informati...
Copy-paste to fixed cells macro searchvalue
Hello, How are you? I've been looking for some help in the forums because I'm new to macro programming and have to develop some sort of line code...
Macro for copying data onto another sheet
Hello, I have a workbook that contains 8 sheets of different states. These sheets have data of five differenct products' sales and achievements fi...
Split data from one sheet into many sheets
Hello, I have extracted data from our accounting database (account code, journal number, reference, date etc). Now I want to split the data so tha...
