The discussions
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 ...
Reading excel file dynamically
Hi I am preparing a master excel sheet say it is "master-1" work book. When I enter the data sheet (another excel work book but in that sheet name i...
Number to word in excel
Hello, How to convert a numeric value into English words in Excel plz show that formula Configuration: Windows XP
I forgot my password
i forgot my yahoo password & details only id i have. what can i do Configuration: Windows XP / Internet Explorer 8.0
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...
Momery card password reset
Hi, I have forgot password of my memory card in Nokia 6270 model Please Helpp.. Configuration: Mac OS X / Safari 525.13
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...
Password starting
Configuration: Windows Vista / Firefox 3.6when i start my windowsxp a panal will appear on the scren telling.a problem is preventing windows from accu...
How do u delete msn if u forgot your password
hi how do you delete your msn if you forgot your password
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 ...
I forgot my password &dont remember my postal
i forgot my password for yahoo.com and i dont remember my postal code how can i get my password back Configuration: Windows XP / Internet Explorer 6....
Excel formulas
I need a formula that will allow me too add the number of red cells. Can anyone help please Configuration: Mac OS X / Safari 525.13
Acidently deleted mail
ACCIDENTLY I DELETED MY MAIL FROM GAMIL-ACCOUNTWHICH IS VERY IMPORTANT IN MY LIFE.... SO GIVE ME SOLUTION HW CAN GET IT BACK....
Make my folder protected with password
i want to make my folder protected with password so that all cannot access them ,please tell me the solution for it thank you..
Iphone apps install into 2 iphones
Hello, I have 2 iPhones(2G and 3Gs). I have downloaded 1 iPhone apps(eg. Purchase IM+) in iTunes. I would like to install into 2 iPhones. Am I...
Excel
I am working on a balance sheet i want a macro that can adjust the difference between assets and liabilities by increasing long term debt and i want i...
Web sheet design
Can I build a spread sheet in excel with several columns of information and import that to a web page? I have no experience building web pages but I k...
