The discussions
Excel 2007- compare columns - return values
Hello, Excel 2007. I have 5 columns A, B, C, D and E. Column A and B are of equal length, column C is longer. Columns D and E are still empty. ...
Formula to dup information between sheets
Hello, I want to be able to type information into one sheet in an excel doccument and then based on the information i input into column E have it ...
Auto schedule to send mail
Hello, I have an Excel file on desktop. Every week on Monday this file is to be sent to my boss as attachment through Yahoo mail automatically.Which...
Background color of cell in excel
SolvedHello, I am trying to write a simple formula that will give me the backgroud color of a cell (in Excel). Something along the lines of, if background ...
Sending a picture via e-mail
Hello, I work on gmail in Windows XP - all works fine but cannot send a picture or a document from my folders. Recently activated Outlook Express...
Hack password
Hello, please help me someone using my yahoo email and he changed my password now i can't open it..its really important to me,tnx! Configura...
How i lock or password to my pendrive
Hello, hello sir how i lock my pendrive Configuration: Windows XP / Firefox 3.6.4
I forgot my password and my alternate adress
Hello, hmm i forgot my password and my alternate adress what can i do?? Configuration: Mac OS X / Safari 531.22.7
Cannot browse or see my flash
Hello, Respected all I tried allof your solutions They are based on the fact that the system can SEE the drive. In my case it detects it but does...
Calculation of month days
Hello, i want to change the total no. of days every month,like juky caries 31 and august cary 30 and feb cary 28 , so according to the month I want...
Excel vba copy button to another document
Hello, Bascially, I created a button in Document A which can help me to sort a table ( the button consists of VLOOK UP in data from another document...
Return $ value by applying enbeded formula
Hello, May I know what formula to use for return of tax amt value (3) of table C. be automatically lookup to the enbeded formula corresponding to ...
Automatically copy cell from workbooks
Hello, I'm using Excel 2003. I have multiple workbooks all stored in the same directory. I want to copy data from a partiular sheet called Budge...
Search text in cell
Hello, I have a macro that can pull the body of email in excel file. I need a code that will help me to search one of the sentence in the body ...
Transfer from one sheet to another.
Hello, I have an Excel workbook that I need help with. On sheet one I have a column with client's names (B6-B35, B37-B66). On this same sheet I ha...
The boss is breathing down my neck!
Hello, Hello, I have an Excel workbook that I need help with. On sheet one I have a column with client's names (B6-B35, B37-B66). On this same...
Enabling macros on a password protected xls
Hello, Sub Macro2() ' Macro2 Macro ActiveSheet.Unprotect ("engineroom") ActiveSheet.Range("$A$2:$N$103").AutoFilter Field:=1, Criteria1...
Copy command within a macro
Hello, I built a macro to copy data from a worksheet tab to another tab. The size of the data file varies so bult the macro like this but it still o...
Sorting and combining rows...
Hello, I have to sort rows based on their cell values in MS excel For ex.: Task Style A B C D E...... 12 1 0 2 4 3 45 ...
Need to chose one data element from 3 columns
Hello, I have an Excel spreadsheet where I want to populate Column D on my spreadsheet. Column D should be populated by 1) Column A if there is a ...
Browsing problems
Hello, my name is Edward and I have Cect5188(china mobile), how can I activate and use operamini for free? Configuration: Linux Mandriva / Fire...
Can i buy the product key without paying?
Hello, I am a fans of assasin creed 2, i wanted to know how can i get the product key without hacking and paying. Thanks a lot. Configuration: ...
Copy and paste vba button
Hello, im aiming to create a button which allow me to input data from the other document. However, the simple "copy and paste" doesnt not work nor t...
Password and secret question changed
Hello, Someone has changed my yahoo password and my secret questions too. so, please suggest me what should i do for recover my password?
One column formula different rows
Hello, I have one formula for a column and 100 rows. The formula takes data from several different column cells on the same row. If I want to use...
Conditional formatting/formatting in vba
I need some help with Conditional Formatting/Formatting using VBA. I need a VBA code that will look at one cell and set the conditional formatting ...
Usding macro to pull information to worksheet
Hello, I am new to excel. I want to create a function in my spreadsheet (Sheet1), that when I click on a button it pulls information from Sh...
Ram
Hello, can i retrive my message in facebook???? Configuration: Windows XP / Internet Explorer 8.0
Conditional formatting a date 8 months on
Hello, I am trying to set up a conditional format to change the colour of a cell 8 months from the date in another cell. e.g. when we accept a mai...
Password for g five mobile
Solved/ClosedHi, What is default password for G FIVE mobile phones ( G FIVE U888)
How to add time reminder in excel file
SolvedHello, I have made a work to do list and I would like excel to remind me at every task time. as I have made a column for work to do item and ti...
Spaces betwwen names in combo list
Hello, I have a list of employees, in and out dates as the status (active or inactive), my idea is to show up the employees with the active status...
Excel formula generation
Hello, I have data spaced 264 rows apart that I need to extract from a massive mess of data. Basically, I need to tell excel to pick info from cell...
Conditionaly copy from tab to tab
Hello, I have posted a question here before on a similar subject and got excellent help with a VB macro, however the problem persists as people in...
Excel 2007 please help!
Hello, I am in Excel 2007. I have data from a formula returned on approximately 200 rows in column K. Because the forumla is only true for s...
How to produce my leaderboard
Hello, i have a column with names in them bob sam dave etc etc and in the next column i have score (calculated by adding up a series o...
Compare columns
Hello, I have two columns of IDs. Column A is the bigger of the two. Column B has IDs that are part of Column A. How to produce all IDs that are n...
Moserbear sd card password
SolvedHello, I forogot my Moserbear SD card Password. So i can not attach this card is another Mobile Please HelpConfiguration: Windows XP Internet Expl...
Excel-macro link between 2 documents
Hello, I am working on a table(in document A) which needs to be referred to another document(document B, not sheet 2 of document A). I used macro to...
Macro help
Hello, I'm very, very new to vba. I have 2 worksheets. Sheet one has a long list of invoices and details. In sheet two I would like to have a user i...
2 spred sheet- 1 pivot table
Hello, I have 2 sheets in a file and both have some similar data in columns and some colums are diferent in both sheets , now i want to manage bot...
Forgot my hotmail password & secret answer
Hello, I have forgot my hotmail password & secret answer.Please find it & send it to under mention email address sa_chi123@hotmail.com. Forgot...
Can't open word document
SolvedHello, i can't open my docx word document.i'm running office 2007 and i'm clickin all my word documents and getting the same response "the file is n...
Assign value to variable (excel vba)
Hi I have a variable name CountNumber. I want it to have a value from the formula "count from A2:A500 range. How can I write the code in VBA with...
Error 800a01a8
SolvedHello, I am having this error every time I try to save a file; " Could not complete the operation due to error 800a01a8". Plus this is the code ...
Copy value of a cell if it is closest
Hello, I would like to compare cells A1, B1, C1, D1 with cell F1. I would like to copy the value of the Cell from A1, B1, C1, D1 that is closest...
Trying to copy one column determined by input
Hello, i have one master work book with 70 sheets and i need to copy specific columns from other spreadsheets with the same sheet names and count ...
Excel 2000 question
Hi there, hope i can get some help with this. i have office 2007 at home and have created a sheet,....but my excel 2000 at work wont let the cond...
Disable buttons in macro
Hello, I want to know how to disable the buttons or grey them out in the macro window, when we click on Tools > Macro > macros > we get the window...
Open specific xl spreadsheet
Hello, Plse help! I save info from one spreadsheet to another.When i press the save button and the info goto sheet 2 and the word "filter" appear in ...
