The discussions
Excel formula help
Got a tough one here I'm trying to figure out. A B C D Wo...
Will cancelling javascript help?
Hi.Deb Blond.Have windows 2000 on my computer.Only need,Outlook Express to send & receive my Emails.Emails not being successfully accepted for being s...
Password removal
how can i remove phoenix bios password on my acer extensa 5200?pls help me
Hide rows if have zero value in multi-sheets
Please note that I don't want to make filtering, what I need is to Hide a range of rows if they have zero value in specific columns in Multiple sheets...
Function conflicts...continued
hiii there was some misconception m again asking my question i have some columns in excel sheet out of which i have to write macros to validate them...
How to attach module with excel
How to attache Conversion Module in all New or Old Excel worksheets, or when we are open the Excel worksheet then automatically activate this module ...
Conditional formatting values vs. formulas
How can I use conditional formatting in Excel 2007 to differentiate between a cell that contains a value vs. one that contains a formula (e.g. starts ...
Function conflicts...
Hii all I am writing validation functions for alphanumeric and email using macros in excel 2003 but only one function is getting executed another o...
Copy entire row from one tab into another
Hello, I'm trying to automate a process where I copy an entire row after a certain condition in a cell is met into another worksheet/ tab. Also afte...
Can i burn .pdf files to a dvd r/dvd rw
ClosedHello, can I burn .pdf files unto a dvd r/dvd rw disc? if anyone can please help me as its very important? thanks, jenna
Excell if equations
if product x is > 15 then multiply by 3, if x is < 15 but > than 5 then multiply by 2 and if x is < of 5 then multiply by 1.5 Configuration: Window...
Hello
I have Windows xp on mt HP MINI Laptop and im doin a powerpoint for school and the school has windows xp also but they have 03 powerpoint will it stil...
If question
I have the following formula that works in older excel, but when I use it in 2007 it give me a #value! error, but formula works=IF((C18-D18-E18-F18)=0...
Help me how to install my office 2007
Hello, Ii am trying to install my office 2007 in my system WINDOWS7 (operating system) but it stuck in hte middle and saying that set up cannot find ...
Cant remember password on sd micro card
Hi, I cannot even remember setting a password on my sd card and it comes up with password. I have tried the usual 0000 which i use for bluetooth c...
Excel formula
Configuration: Windows XP / Internet Explorer 6.0 I HAVE A FORMULA THAT ADDS COLUMN A AND B AND IN COLUMN C IT ADDS COLUMN A AND B AND THEN MULTTI...
Comparing columns and returning value
Configuration: Windows Vista / Firefox 3.6.3 Hi, Hopefully somebody can help me here! Basically, I have 4 columns. Column A has a li...
Copy and paste cells until reach end of data
Hi, This is my first time trying to program in VB and I have no idea what I am doing! I have data that I would like to copy and paste within the same ...
I want to operate a drop down box with a cell
I want to operate a drop down box with a cell button - i have found the cell button but i need a simple explanation how i write a macro for the cell b...
Hours by job in timesheet in excel
Hi, I have the following time sheet that lists each employee and each day they worked, the job they were on and the number of hours worked on that...
Jhgjhlkj
I want to make such a formula in excel; If the value in A column is equal to "+"; then the conditional formatting for the result row should be as; ...
If/then using an external text file macro
Is there anyway to write a macro that will scan an external text file for possible column values? I have very large datasets that I have to "clean"...
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. ...
Copy filtered table columns in vb
On change of cell content in Sheet2:A1 from defined list, I want to filter a table in Sheet 1 and then copy the contents of a column from the filtered...
Getting reminder in excel/outlook
Hello, I want to get reminder from excel or outlook when the value of a particular cell in the excel crosses a particular limit......like i want to b...
Macro application
Hi, I wanted to create a application, like i have excel sheet contains 1000s of employee details, at the end of the column (Column H), managers name w...
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...
Excel macro to change a cell formula
Hi, I have three spreadsheets, one in which I enter data on a daily basis. The second collates this information by using referencing directly from t...
Email 2007 excel gmail
I recently bought a new computer with WIndows 7 and Office 2007. My email is Gmail. I was in an excel spreadsheet and wanted to send it as an attach...
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...
Excel script help!
Hello, I have a question about creating a (basic?) script that will pull some information out of a rather large excel file for me to eliminate a lot o...
Copy/insert and keep range membership
Thanks Venkat. This isn't quite what I'm looking for. I have data in column A, rows 1 through 5. Cells A2, A3, A4 are a range called myrange. ...
Ms word on desktop, but now missing from prog
I installed an icon for Word 2007 on my MS7 system. The icon is now on the desktop, but the listing is missing from the programs file in the start m...
Pop-up message box help in excel 2007
Configuration: Windows Vista / Internet Explorer 8.0 Good morning, I am trying to create a pop-up box in Excel using VBA. I have to admit I have o...
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....
Conditional formatting in excel
Below is a small sample of the data that I am working with. Each column represents a year and each row represents an account number. What I would li...
Excel conditional formatting
What if the data i need to compare is in the other Tab!!!! ... How can i Compare it!!>> Pls. Help
Hid ad
what is the formula of varied sum. Configuration: Windows XP / Internet Explorer 7.0
Photo image disappears in pdf file
Hi, When I add a photo image to a word document and do save as PDF, instead of photo image I get gray box. What do I need to change to make the phot...
Answer to how to recover gmail password fail.
hello folks, the answer given for recovering the password for gmail account is failed.so please give me some other solut...
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....
Password recovery
How to recover windows password?
Convert mm/dd/yyyy to mm/yy in excel 2007
How do I convert mm/dd/yyyy to mm/yy in excel 2007? Configuration: Windows XP / Firefox 3.6.2
Excel vba user list
Hi. I would like to create an excel spreadsheet that opens up to a dialog box where the user has to enter in 4 different values. For example, t...
Excel masters plz help
dear all, I will tell you the question in more detail. In sheet1 I am entering the data for the whole year, in column f I am entering names.(10 di...
Excel msgbox alerts - popup
I am trying to create a stock trading template in Excel. The template/worksheet will be minimized/running in the background while other applications r...
Lost administrator password
Hello, iv lost my password. the administror password. and i dont have the disk. lost it as well. How do i switch it over to another user on my compute...
How to run a macro in excel
sdfad Configuration: Windows XP / Safari 532.5
Is there a macro which will sum cells
Hi all I wonder if you could help. I have a long grocery list which although I can sort alphabetically I am finding it difficult to sum similar gr...
Vlookup if value is more or less than 100k
Hi I have 4 columns on my Sheet 1, A=Accounts B= Actual C=Budget D=variance One the next sheet, I want to do a vlookup that is A is equals to ...
