The discussions
Validate
SolvedConfiguration: Windows XP / Firefox 3.5.9 Hey frnds I almost have a same problem: I need to validate columns for alphanumeric and email forma...
Helo data extrating
SolvedHello. I have a File which contains 3 colums Mobile No , Name And Address in Sheet one. Each file contains approx 500000 data. in sheet 2 i h...
Macro to delete blank rows?
SolvedI have a spreadsheet where I would like to 'record new macro' to delete all rows that are blank. If I filter on blank rows and delete....the macro wi...
Why won't this work?: update graph's year vba
SolvedHi, My graph has a timeline of one year. After that year the timeline needs to be updated. To get the current year I have used the functions TODAY...
Conditional formatting problem
SolvedOk I hope someone can help, I have a spreadsheet set up so that it flags up to me if two certain codes match by turning the cell yellow. I also have i...
Moving specific data into separate worksheets
SolvedHello, I have a list in a column as follows: DAY TYPE PHASE 1 ...
Bios password
Solvedi have dell inspiron i forget bios bassword i cant open it its end of 59b Configuration: Windows XP / Internet Explorer 8.0
Hyperlink macro
SolvedHi Have a customer profile sheet that has a new customer number each time it is opened. Details are filled in for the customer then a post button is...
Macro to copy and paste values
SolvedHi I am a complete novice when it comes to macros. What I am looking for is a macro that when run looks in Cell Q7 on Sheet 1 to see what number is...
Please help macro or formula excel
SolvedI've 4 columns and 10000 rows like this : Month Plant Area Budget Jan ........ A1 ........01 ........ 1000 Jan ........ ...
Multiple tabs set row count based on sheet 1
SolvedHi Sheet 1 contains > 1000 rows of populated data. I need to create x number of tabs each containg the next 25 rows from the sheet1 data. ie 1000...
Extract specific data and convert to a date
SolvedHello, I have a column full of cells that all have the same string with a few different numbers. Here is an example from cell K319: 53T044 11/...
Copy text from cell below based on condition
SolvedHi, I'm looking for a macro that will copy the text from the cell below to replace the cell above where the cell above meets a certain criteria. ...
Vba inserting row and keep range membership
SolvedIn VBA, how do I copy/insert (in place) a row and ensure that if the source row intersected a column range, that the new row would also be in the rang...
Count number of trips when duplicate entries
SolvedI have list of all the prescriptions we got for the year. A new row is created for each medication. Col A shows the date, Col B shows Pharmacy Name...
Sum searched criteria
SolvedThis code works great at searching based on the userform criteria and then in the message it states the count of the rows pasted into the spreadsheet....
I need to get a sum from multiple 'if' cells
SolvedI have a spreadsheet with the following formula: =IF(ISNUMBER(E5), "20.00","") If data is entered in cell E5, the cell below it will have 20.00....
One week color
SolvedHi, Is there any formula to make my one week date in to color red then next week in to color blue? I just want 2 colors interval each ever week of the...
Match with conditional format in excel 2003
SolvedHello Internet, I am in a bind here as I have exhausted my excel knowledge on this problem. I am looking for a way to highlight (in red) a cell wh...
Excel 2007: reading data from sheet to sheet
SolvedI am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting ...
Images don't print when printing selected pag
SolvedHello, I am using Word 2008 for mac. Some images don't print when I print selected pages, although these same images appear when I print the entire...
Excel vlookup macro
SolvedHello, I am working on a project to create a simple VLOOKUP. I have created the macro and it works well, but now I am looking for some advise on ...
How to romove 512 mb micro sd card password
SolvedHi i m using nokia 6300 mobile & 512mb micro sd memary card & this memary card is locked i forgot the password plz tell me how to unlock memary card p...
Interesting question for excel champions
SolvedHello, Interesting Question Guys: Suppose Sheet 1 Is "Data" Sheet And There Are Too Many Rows... Like A3 Is S.No B3 Is Supplier Name C3 I...
Vlookup column number searching.
SolvedDear All, I'm currently using a VLOOKUP to populate an information table im creating however im still adding columns to the sheet which holds the i...
Coping rank for whole dataset in excel
SolvedHi i want to work out the ranks for my whole data set, if i type in the formula for the first line then drag it for the rest instead of working out ...
Automation of running excel macros
SolvedHello, I have a macro in excel which needs to be run once a day and i dont even want to open the excel sheet. How can i make this process automatic...
Formula help
SolvedI'm trying to create a formula to look at the values in a complete row and if 3 of those values in a row are pass then it will fill in the cell with Y...
Growing list of chart data
SolvedHello, Column K contains dates, column L contains amounts. I want to create a chart out of this data. The issue is that the list of data is growin...
Creating if statement to filter and add.
SolvedHI, i am trying to create an IF statement to filter a row and then add the numbers in another row on those filters. so for example AA ...
How to align all common list in excel?
Solvedi have 4 columns. the first two (A & B) columns are list of cheques i issued. then the other two (C & D) columns are list of cheques encashed from Ban...
Copy filtered data and paste values
SolvedHi, I found this code in this forum. It selects data based on the filtered rows of data and then it pastes it in another sheet based under the name o...
Coping cells with a loop
SolvedHello, I am stumped on what should be a very simple macro. I am running a macro that is using a look-up table to compare the values in column G. ...
Changing a value using a look-up table
SolvedHello, I am looking for help on writing a macro that will perform a VLOOKUP formula that will compare the value in G2 on Sheet1, to the value in A...
Copying % formula
SolvedHi, I regularly calculate a series of number as a percentage of a sum that remains constant (expense item as a percentage of total expenses, for eg.) ...
Help on excel formula
SolvedI need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...
Comparing column values
SolvedI am trying to compare two columns to see if they carry the same values - column A has 556 values (starling at line 3), and column B has 69 values (st...
Identify two or more are same or not in excel
SolvedHi Everyone, I have an excel formula question that someone might can help me with. A B 1
Count 2 values in one column and 1 val in oth
SolvedHello, I have two column lists (two values in first column and one value in the other) e.g. Column A has the following values: A B C B B A C ...
Moving data
SolvedIs there any one who can kindly come to my rescue!! I have been presented with date in the form: A B C D E F G H I J ? My aim is to pre...
Match a string to a col & increment by 1
SolvedI have two sheets with data as follows: Sheet 1 String, result A0101 Format of string in Sheet 1 column A: Axxxx (A - alphabet a to z, x num...
Merge rows of similar data
SolvedHi, 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
Solvedhi , 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
SolvedHi, 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...
Someone has stolen my password
Solvedhi, someone has stolen my email password.. and iam not able to get it back. how should i get it back?
Memory card password
Solved/ClosedHello, i have nokia 3110c and I had put a password for the memory card and now I have forgotten the password so if u can help me thank ...
Changing cell ranges in all series of a graph
SolvedHello, I have a graph with 5 series on it. ='Entire series of data'!$E$17,'Entire series of data'!$E$5066:$E$6375,'Entire series of data'!$I$17...
Find max valu every 10 rows &mark row as keep
SolvedHi, I need help creating a formula in excel to Identify the Highest and Lowest values Every 10 rows THEN Identify those two rows...
