The discussions
Convert number currency to text
Hello, Can you help me convert number currency to text. Ex. 1,235.16 as One Thousand Two Hundred Thirty Five Pesos & 16/100 Only Thanks
Finding matches within groups of cells
Sorry for the confusing title! An example should clarify. Here is a link to an image of the excel program I reference in my question: http://i.st...
Comparing partial words in the same column
Hello, How can I highlight cells that have repeated words in the same column. For example, in column A, I have words like AMC company, ABC company...
Excel formula not working right
Hello, I am trying to write a formula for the following situation and for some reason anything I come up with is not working properly: if R2=...
Convert date
Hello, Please how can I convert DDMMYY(200511) to DD-MM-YYYY(20-05-2011) in excel Configuration: Windows XP / Internet Explorer 8.0
Using unique number to filter information
Hello, Hello, Can anyone help, setting up childcare voucher scheme and have set up register in excel in sheet 1 a2- voucher no ie. 1 (unique...
Add rows in sheets based on an entry in theor
ClosedHello, I am trying to create a row in a separate sheet with the data that was inputed in the original sheet. Can you help? Configuration: Windo...
Compare two columns text
Hello, If the text of any cell in column-A matches with the text of any cell in column-B, copy entire row to next sheet. Like Column-A ...
Excel '03 formula to count items in 2 columns
Hello, I just need a little help. I'm trying to use the CountIf formula to reference two columns of data. I've been using this formula: =COUNTI...
Excel
Hey - created a speadsheet - has 13 sheets. A "Master" and one for each "month" of the year. Master containes rows of information: Unit numbers, date ...
Find the value in a row of a matching column
Hello, If you are able to help, I would be greatly appreciative! I would like to find a formula that would look up the value in a cell, find the...
Macro error when trying to paste ???
I wrote a macro to search for a value in a different file/workbook, copy the row (if the value is found), then paste it back to the original workbook....
Excel 2007 if function
SolvedHello, Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine how ...
Macros for making a graph in different tabs.
Hello, Hey Experts, I recently tried to use macros to make graphs. I have more than 15 tabs on my excel. Each of them have a similar data with ...
Macro/formula in excel
Hello, I want to search for a word in the format eg.ABC-2012-123( where only ABC is fixed and the other numbers after hyphen keeps changing) in ea...
Vba - search engine help
Hi guys, These threads are really helpful but i still cant get mine to work. I have created a knowlege base on excel for all the fixes on my serv...
Getting data from another worksheet
Hello, I am having 2 worksheets in a workbook sheet1 consists of a data like this: Country name Site engineer Name Contact Details Ben...
Copy/paste macro for excel 2011 for mac
Hello, I am in of help! I've tried searching the forum for a code that will work but sadly i've not found one. I am try to create/code a macro or b...
Excel macro to create files based on column
Hello, I want to create a macro which creates files based on contents in column AJ. and I want the macro to copy the data from original sheet...
Conditional formatting 4 colors and words
ClosedHello, I have a report that I have to create. If a certain cell is 0-9%, I want the cell beside it to turn green and have the word excellent ...
Convert row one into three column
Dear friends, Could you please help me to convert below given data into required format Current situation 12345 60 12345 50 12345 40 124...
Macro to search, find, copy rows and replace
Hello, I am trying to create a macro to search for a number from one workbook in another workbook, and then either copy the entire row or copy the ...
Copy particular columns to next sheet
Dear friends, Plz help me to do the below requirement Current situation sheet one PTS invoice# status amount proc.date 1234...
Find data in another spreadsheet
Hello, I need my stock checker to pick up data from our suppliers spreadsheet which they change daily. So what i need for example is: To mat...
Vba - transferring select data to new sheet
SolvedHey there, I'm trying to create a macro for an Excel 2003 spreadsheet that will take a record (a row (or rows)) that I've already selected into a new ...
Forgot phone lock password
ClosedHello, I forgot my Phone lock password of Samsung E2510 how to solve without removing the data ? Configuration: Windows XP / Safari 536.5
Convert row one into three column
ClosedHello, I need to convert below given data into required format Current situation 12345 60 12345 50 12345 40 12435 60 12435 40 ...
Excel: how to create a complex date formula
Hello, I need to create a date formula that only includes weekdays. I want to have a formula that does (=previous date+1) for 5 boxes and then...
Excel doubt
Hello, I am using excel 2003 and pl help me to solve the below issue I want to compare two cells from one worksheet to other to write value ...
Sum using macro?
Hello, So sorry for my continuing inability to get my head around macros! I'm trying to workout a new spreadsheet and would really appreciate any...
Excel formula: copy data and add "0000"
Hello, how do I copy data from worksheet 1 into worksheet 2 (i know how to do this part), AND 1) delete the 4 digits at the end (i know how to do...
Number inti words in excel
Hello, Friends I wanted to easy way to do the programming in view code. I was try all way but i was failed to install if you have any other easy way...
Conditional copy of row to other worksheet
Hello, I have a 7 sheet workbook which contains a part number in column A of each sheet with details following it. I am trying to write a VBA code...
Urgent i need a formula, is a challenge
Hello, I was wondering if anyone can help me, I have a Column with Text, and i need to find the word Cash on that column, and if there is such a w...
Excel: empty cell in 2007
Hello, When presenting raw of data into a chart there is an option to present empty gaps as zero, gaps or connect the dots. none of teh option is wor...
Paste data into alternate blank cells
Hello, in using Microsoft Excel 2007, I'd like to paste data from one column into a another column that has some data in it along with some blanks ...
I forgot apple i pod password
SolvedHELLO, i forgot my apple 8gb passeord bearning the model nos.A1285 and serial nos. 5U9203UK3QS Configuration: Windows XP / Internet Explorer 6.0
Vba dynamic paste after values
Hello, Iam trying to do more or less a copy paste Macro in excel. The date comes out in the following format: Entity-----Account1----Account2 ...
Data validation and if statement
Hello, I have an issue trying to match If statements with data validation. I have a cell (A1) with a certain result calculated (e.g.: G0,G1,G2)...
Macro to create worksheets & add dates
Hello, I have a worksheet (Excel 2007) that has two master pages with data, Weekday, and Saturday. Every month the tab Weekday is copied and renam...
Macro to cross reference workbooks
Hi all, I am (VERY) new to macros, and I am trying to create one that searches the cell in Column D in workbook 2, cross references it by the same...
Autofill list from internet
Hello, I have a list of over 3000 company names in India. I need to check for each of them to see if they have their own website or not. I am d...
Need macro to copy the searched data
Dear Friends, I am having a bug report. In that different developers will have a bug for each module. And each modules are in different sheet. ...
Macro to delete specific number of rows.
Hello, i have a imported text file into exel and i want to delete some specific number of rows after specific number of row say i want to delete ...
Comparision of excel data
Hi, I am looking for comparing calues of sheet1 with sheet2 if the fileds in sheet1(coloumn A) is matching with filed in sheet2(coloumn A). If the ...
Search for specific text & copy row+next row
Search for text and copy row + next row to different sheet I have sheet1 and sheet2. All my raw data is in Sheet2 and Sheet1 will be summary report. ...
How to use filter formula
Hello, how use filter formula Configuration: Windows XP / Internet Explorer 6.0
Vba code to conditionally copy the data
SolvedHello, need help! see I need a vba code that can copy data from sheet1(raw data) to sheet 2,sheet3 and so on is certain condition matches..exam...
Date -time subtraction..
SolvedHello, hi again,need help i need a macro that will subtract date-time in column A with the Present Date-time and display the value as number of da...
How to get sub strings using delimiter
Solvedhi, i want to copy the part of the string in a particular cell to another sheet. e.g. the string is cell A1 is as below: EVENT_ID NUMBER(10) ...