The discussions
Conditional formatting in ms excel
Hello, Would appreciate if you could please help me with the entire process how to do do conditional formatting for one entire row- which contai...
Xl file
Hello, Hi,I need a help for my inventory sheet. I have to create a sheet as shown in summary.That sheet is picking data from Pivot table and that ...
Paste inserting blank cells
ClosedHello, Using VBA I want to copy a column with a variable length and paste into another column inserting 2 blank cells for every value pasted, like t...
Need macro coding
ClosedHello, I NEED SOULTION. i HAVE DATA LIKE BELOW FORMAT. A B Apple Apple Apple Apple ...
Excel - select last 25 records
SolvedHi I have a spreadsheet that is entered into daily a list of actions taken in a department. This needs to be printed weekly and displayed. Obviously t...
Auto update master sheet
Hello, I am trying to prepare a master sheet. My problems is as below:- There are 4 different work stream owners and all of them have access to...
Excel - removing different rows in 2 sheets
SolvedHello, I have two worksheets containing a different number of rows. I want to delete all rows in sheet 1 that have a value in column A that c...
Help require to find correct formula
Hello, Received one issue on 22-Sep-11, the turnaround time to solve this issue is 6 working days therefore the Expected date of Closure is 29-Sep...
Excel
ClosedHello, i want to highlight a cell if there is no value in the cell. I am using the isblank funtion in the excel but how do i set the color code ...
Compare columns and copy
SolvedHello, I need a Macro to do next : i have 2 sheets Sheet1 and Sheet2. In Sheet1 column A has a variable range of values i.e. A2 : A... Column B is e...
Dont know the password
ClosedHello, I've got one Dell Inspiron 1440 Laptop that I've bought from my friend. The problem with that computer is when I start what that's appear a...
Need to find correct formula in excel- urgent
Hello, Received one issue on 29-Sep-11, the turnaround time to solve this issue is 6 working day. In my case A1-9/29/11 and TAT for its closure of...
Excel filter with macro
Hello, I have a excel with different criteria , in which i have to filter according to three criteria's . * And finally i have to pick a ce...
Require correct formula in excel
Hello, Received one issue on 22-Sep-11, the turnaround time to solve this issue is 6 working days therefore the Expected date of Closure is 29-Sep...
Convert the fraction to month and year
Hello, I need to convert 05/10 to Month and then Year. i.e., for Example it should come as May 2010. Please give an idea to get the above...
Creation of dropdown from dynamic list in vba
SolvedHello, I have been trying to make a Macro that can create a dropdown list from a dynamic list in column A. So far I've come up with the followin...
Excel:sorting2
Hello, Would be very thankful if You could help. I have 2 columns with country names i need to find which country is most used and sort it DESC ...
Vb .net
Hello, Configuration: Windows XP / Safari 535.1 i had created an employee database , but i cant able to retrieve datas from the table so...
Printing the adjacent value of matched cell
Hello Sir, I was stuck into finding the value of matched column next cell value, Here is what my question actually is Hello, I have 2 co...
Avg multiple cells in multiple sheets - excel
SolvedHello, I need to average multiple cells across multiple sheets, but not all are in the same column/number. I need to average B35,D35,F35 in Sheet 1...
Create dropdown from dynamic list
ClosedHello, I'm trying to make a Macro that can make a dropdown list from a dynamic list in column A. So far I've come up with the following code: S...
Cndtnl fmt a1 based on a2 based on a3
Hello, I have reduced my question to this simple example. I am trying to set up a conditional format in Cell A1 based on the results in cell A2. C...
Apacer password
ClosedHello, Good eveing,i forgot the password numbers of my mini sd 2GB from mobile phone. So,i wanna to how i can unlock this SD card. Can u help m...
Macro to insert data to changing cells
SolvedHello, I'm trying to write a macro in excel for inserting input text to a specified cell. I have already an InputBox specifying the text to be put...
How to insert 3 logical condition in excel,07
Closedsuppose in column g5 there is some values ranges 5 to 50, when g5
Can;t type any pass words in
ClosedHello, I can get to all web sites, if they are in my history. just can;t type into site address bars. just a line comes up blinking??? Configu...
Change date format in excel
Hello, Configuration: Windows 7 / Firefox 6.0.2 My spreadsheet has date in cells as: 7/1/2003 but displays as Jul-03. Need to have date in c...
Master password for dell studio 1535
ClosedHello, To all the wonderful voluntieers on here,can some one please with all respect help me get the master password for my lock dell studi...
Excel merge text files
SolvedDear Forum Members, As I am not a VB expert I have copied some codes and edited to suit for my purpose. My idea is to combine many .pyc files in a f...
Master password
ClosedHello, i need i master password for my dell studio 1535 which is locked and i can do anything about it. Configuration: Windows 7 / Internet Exp...
Get columns from one sheet to another
ClosedHello, i have one sheet with values in number of columns. Its columns may not change but its rows will increase. I would liketo get some o...
Excel:sorting
ClosedHello, I have 2 columns with country names i need to find which country is most used and sort it DESC and by A-Z (most common used countries are m...
Copy rows and paste in a single column
Hello, I have multiple data rows and columns in excel format 0.00111 0.00111 0.00111 0.000018 0.000018 0.000018 0.000017 0.0000...
Jump to cell
Hello, I have two columns A and B. Suppose i write 3 in Cell A1, then I want the cursor directly jumps to cell B3 and value 3 is filled in the c...
Excel text to columns converting pm to am
Hello, I have a spreadsheet that has 9/11/2011 1:33:03 PM in the display bar, 09/11/11 13:33:03 PM in the cell. When I perform text to columns to...
How to remove powor on password of my g five
SolvedHello, How to remove powor on password of my g five mobile,plz help me. Configuration: Windows XP / Internet Explorer 8.0
Forgot username, password
ClosedHello, i have a dell inspiron 1545 and i cant log in i forgot username/password. please help, how can i remove password. WINDOWS 7 ; service tag...
Compare two excel columns of differant size
SolvedHello, i am having two excel columns of differant size..Both the columns contain mobile numbers..i have columns A containing all the mobile numbe...
Macro help - search for text in excel
ClosedHello, I've been trying to wrap my head around how to do this but haven't had any luck -- I want to search for text in excel in a spreadsheet of 40...
Excell mess
Hello, I want a price from Column E if it has in Column F (next to it) the number 1 to go to Column Named GRoup 1 if it has number 2 tou go to Group...
Better looking charts for office 2010
Hello, I'm looking for better looking charts for Office 2010. Currently my charts look really ugly and unclear. I'd like to get them look like this...
Copy paste rows in excel across worksheets
SolvedHello, I'm trying to create an excel macro that will copy a sequence of rows from 2 different worksheets and paste them in a third worksheet using t...
How i use the pasword?
Hello, hi plz tell me how to use pasword?
Word files converted into pdf, cannot be open
SolvedHi, Many of my word files have converted into PDF file. On the other hand those files cannot be opened /viewed. What can I do now to convert those fi...
Forgot the password
ClosedHello, I have a Sony vio laptop that my grandpa gave to me however he seems to misplaced all the cd's that come with it and he has forgoten his passwo...
Data validationin logical function
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 da...
Stop uploading all mail.
Hello, Dear Sir, I had a Microsoft outlook Configuration in my PC, but due to some problem in PC i Formatted all the things keeping all All the...
Excel conditional formatting vba
I am trying to format excel to do the following If A1 is "Bad" B1 to G1 Cell color is Grey If A1 is "Good" B1 to G1 Cell color is Green If D1 is ...
Msn recover password
Hello, Configuration: Mac OS X / Safari 533.21.1 I forgot my msn password and secret question what can i do thanks
Excel if formula text vs numbers
SolvedHello, I am trying to run an If formula that if the cell range contain text then use Counta but if cells contain number use Sum. At present I'm us...
