The discussions
Excel macro for moving content
Hello, I need a macro that will search for a specific set of values in a specific column for each row of a subset of rows. Example data can be ...
Vba code for a if function
ClosedHello, I need help on the following: Selecting a range on data e.g A1:A14 Searching for a certain value e.g 3000 if query is true then copy a ...
Multi criteria conditional formatting
SolvedHello, I am trying to work out how to reference to cells for an if statement using conditonally formatting (through VBA), I have come up with the ...
Adobe acrobat setup problems
Hello, during the setup of adobe acrobat, an error telling me that it could not connect to the server comes up. how do i fix this or what am i doing...
Comparing data
Hello, I would like to look at two columns A and C and then if they match take the quantity in column D and insert it in Column B. So Column A ...
Excel formula
Hello, I have 1 Workbook with 2 sheets full of data, both sheets have identical data except for 2 Columns, DOB and Last name. I want a Formula on ...
Formulae
SolvedHello sir, your forumlae working fine, i would like to convert lakhs to paises please send .. Configuration: Windows XP / Internet Explo...
Macro to find min value
Hello, I need code for part of my macro that will find the min value in a particular column and based on the min value clear the contents in other ...
Memory card password
Hello, i am shirish, i hava loss my memory card password, so pl. tell me what is my password or solution. so pl. say any body to me how solve thi...
Select the cell that a button is in
SolvedHello, I want to run a macro using a button in Excel 2010 without regard as to the location of the current cell. In other words, when I click a...
How to copy data from one csv file
Hello, I want to copy data from one CSV file to another CSV file using VBA. Please anyone help me in doing that. Thanks, Madan
Excel goal seek doesn't go through a macro
Hello, I'm trying to use the goal seek function of excel to seek out a particular value of a cell (say Y) by changing values of another (say X). ...
Word macro to insert rows to multiple tables
Hello, Configuration: Mac OS X / Firefox 3.5.2 Using MS Word.. I have a few rows to be added to each table; and there are multiple tabl...
Trouble recognizing data in excel sheet
Hi, Dear All, I asked some time back about a question on how to highlight thevalues etc that i entered in an excel file, and Mr. Trowa has...
Installing office 2003 from a cd-rom.
Hello, i have Hp-notebook, want to install office 2003 from a cd-rom, but no luck, i see the files, but it wont't setup.please help smillingking
Code for firm which open excel sheet
dear sir, I want to create a one firm from where i want to open my existing excel file , how can i do this. Please help me. May I use some code fo...
Excel macro help
Hello, I have an excel spreadsheet table (on one worskheet) that has several date rows in one column C, and one cell J12, for a permit number havi...
Copy rows of data from one sheet to another
Hello, I have used the below code to copy selected rows ("x") of data from one worksheet ("QBank") to another ("TestSheet") within the same workbo...
Vba excel last used cell
Hello, I am trying to copy a range of data I have in several columns in a worksheet into one column (all the columns have the same name: OrderID) ...
Compare values and conditions
Hello and thanks in advance for any help. I need to do the following: three ranges in age: >45 between 46 and 55 45 and "values" = 75000 the ...
Password reset
SolvedHello, I can't recall the password on my Toshiba C660/C660D laptop. On entering what I thought it was several times, it is now asking for a remov...
Color column range based on content in cell
SolvedHello Sir, I want to know how to color the column based on content in fixed cell like. In Row No 6, If The Value Of Row 6 Is "Sun" Then Color T...
Outlook won't send emails
SolvedHello, This is not a question, it is a statement. Outlook 2003 would not send emails through my ISP's smtp server. I probably spent 25 hours t...
Memory card password forgotten
Hello, Configuration: Windows XP / Internet Explorer 7.0 I have nokia 2700 classic with one gb memory card and I have forgotten my password a...
Need excel macro
ClosedHello, I need a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to search cell...
Hiding a different sheet in workbook
SolvedDear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...
Report from excel data sheet
SolvedDear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...
Forgot password
Hello, this is naresh i have forgot the pass word of memory card.Please help me Configuration: Windows XP / Internet Explorer 6.0
I need help with an excel formula
Hello, I have a spreadsheet that I am trying to find a average of one column with several rows that if another column with several rows contains a...
Show a range off a drop down menu
SolvedHello, What I'm trying to do is make a drop down menu that when you pick an option from it, the column next to it changes to a list corresponding t...
Excel vb macro
SolvedHello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...
Excel issue
Hello, There are 3 tables, A, B and c, according to the requirement A = B + C. Need to check the value for B, where B = A - c. Table A contains p...
Please resolve my issue ofms excel file highl
Deat Towa, http://www.speedyshare.com/... Please see the below mention link, What i want is, 1. Those bolt which are consumed completely s...
Greater than or equal to
Hello, here is the problem: IF(F4
Need shortcut for full screen in excel
ClosedHello, Anyone give me the Keyboard shortcut to change excel sheet into full screen mode.
Excel macros; clear, compare and replace!
Hi, I need help creating three Excel macro subroutines.... This is for office 2003! The first one clears cells that do not contain "arg1"...
Unknown administrator password
Hello, I would like to ask if anybody knows how to remove admin password if I cant install since I was not log in as admin. HELP! please.,. thank ...
Codes for reminder creation in excel vba
Solved/ClosedHello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...
Can someone help me write a macro?
Hello, I have a large database of information (inventory). The datbase is constantly having rows added and deleted. In column (1), there over 100...
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 ...
Delete #n/a
Hello, I used the following code to copy rows from one workbook to another Do Until IsEmpty(i.Range("Q" & j)) If i.Range("Q" & j) = "TERM" T...
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...
Password neded
Hello, i forget my password and also forget my secret aanswer and i really have an important e-mails there and i need to open that account so can y...
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...
Forgotten password
SolvedHello, i changed my password on my samsung S8300 today, i then turned my phone off, when i turn my phone on it asks for a phone lock, it doesnt except...
Dates and conditional formatting
ClosedHello, I'm trying to create conditional formatting that will do the following: A3= today's date I10: The due date Past due: Anything due befo...
