The discussions
Vba: if 2 checkboxes checked, hide row
Hello, Can anyone help with a macro for hiding Row 1 if two checkboxes (BoxA and BoxB) are checked? Thanks!
Excel macro help required
Hello, I have an Excel Workbook that has 140 names/ID's that have different Composite roles agianst it, I want to create a macro or run a macro so ...
Hi hello i cant open datas from my pen drive
Hello, sir/madam please shut out my trouble, ie.when i go to open my pendrive, its not opning. suddnly its showing Please insert a disk into dri...
How to show more than 255 characters in pivot
Hello, I have a pivot table in which 1 column(nearly 1800 rows) have characters nearly about 2000. But the pivot table shows only 1st 255 character...
Excell macro help required
SolvedHello, I have 3 Excell Workbooks, i need to create a master sheet, but when ever i update the master sheet the data updated shouls reflect in all t...
Moving tabs from 2007 excel to 97-2003
Hello, I need to copy many tabs in a 2007 excel workbook to 97-2003 excel file and I am getting following message: Excel cannot insert the sheets...
Password virus
Hello, My son has watched a you tube clip. Up came the msn message.."You have encountered a .... we have to shut down...." then up came for a second ...
Sheet creating macro
Hello, I want a macro which can collied sheets from different workbook and make one excel and the sheet sequence can be selected manually. Kin...
Excell macro help
Hello, I am wanting to create an excell macro - that filters out the names in 1 column of the spread sheet - I pull a report everyday that gives th...
Letting the user specify which sheet my vba
Hello I have been using many of your very useful articles in the past and they have allowed me to solve many problems. However I am now Very stuck des...
Lost password
Hello, i lost my password and i forget my secret answer too. plz help me.
When message changes from text to html format
Hi, Environment: My outlook 2003 default format is HTML. The Default fond for new/reply messages is Arial. The Problem: I get a message in tex...
Lost my hotmail password
Hello, hello please someone help me, because anyone has hacked my msn account and i think he has changed my question answer and all detail too. pleas...
Complicated excel formula problem
Hello, I need to create a user form based on several columns of data and what ifs and calculations. In my user form the user will enter in a pipe di...
Windows xp is not recognizing any printers
Hello, I own a mac. I have windows XP Professional running under the vmfusion ware. It is not recognizing ANY printers. I have downloaded the driv...
How to comp more than one coln in a excel
Hello, i have two work sheets which have 4 columns of data in sheet. i need to compare the sheets. But the data's are in the different rows contain...
Excel del text - other than-start letters mb
Hello, Input Excel file with one column. Conditions I would like to delete text other than which is having starting letters of "MB" or "SM" an...
Need help in excel macro
SolvedHello Ivan, Ive' been reading a lot of your answers and i'm quite facinated of your skill. I need to create a macro for one of my project and it i...
Power point
Hello, my question is how to put a photo on a power point project ?
Transposing multiple individual records
Hello, I have data with each individual record split down multiple rows, followed by the next individual record. Each has a unique record # in Colu...
Find text cut move and paste
Hello, I have a report in pdf which I can save as text and open in Excel. I need to locate a string of text "Item Total for Branch" in Excel and then...
Using access macro to update sheets1, 2, 3, i
Hello, I have an access macro that uses several queries to copy data into excel. my problem is that i can only get the macro to perform correctly on ...
Can`t open some of the attachments
Hello, how do the activation on windows 2003 to enable the machine to open some of the attachment emails,
Open e_mails 2003 on 2007 problem??
Hello,I am oredy buy a new PC running Vista and windows office 2007, but I want to open my old e-mails on office 2003 and winXP and I can't open them...
Using named ranges to create dymaic graphs
Hello, I successfully created a graph using named ranges. Now in my graph, source data, in the 'value' box, this is the code I have: "Sheet1!myrang...
Excel 2008
Hello, I have a order form in excel 2008 that lists all my stock the unit price and the total price, I then have a Qty column, the idea is that whe...
If statements with free entry
Hello, I am trying to constrain a free fill in column based on another column. I.e. if col A is yes, then col B must be yes also, but if col A is N...
Get answer in color using formula
Hello, i need formula in xcell to get the answer in color. eg: when i write if statement in cell if the answer true "pass" appear in cell in green...
Reset pasword
Hello, Hello i lost my yahoo and hotmail paswords and even secret question please guide me to any software or tools to get back my ids
Vista 64 bit outlook send/rec problem
Hello, I am having fits with Outlook 2007. I can no long send or receive. I have redone all the settings and still end up with a send and receive e...
Excel help
SolvedHello, Ok am not that experienced with excel, so if any one can helo would be great. I have a huge spreadsheet and i am constantly updating it. ...
I have forgotten my password
Hello, i have changed my password and forgotten it in next login. i have made my account 2 years ago and my date of birth was fake and i dont reme...
Checking a row of cells and reporting
Hello, I have an audit spreadsheet listing rooms by the building its in, the room number and a series of answers to questions afterwards detaling...
Excel help
Hello, In my Excel Sheet Column A-------------------Column B----------------Column C 10---------------------------10------------------------3 5...
Excel macro: copy between sheets
Hello, I have sheet1 and sheet2. I want to create a macro: -copy Bx:Dx from sheet1 to sheet2 Bx:Dx -where x from 6 to "get count row number, w...
Excel loop, inner loop
Hello, I have an excel file that has data in a cell that looks like "abcd-123456-efghijk-7890". My problem is that i have about 2000 of this type of...
Who can solve this problem
Hello, how to check 3columns data at 1 time.for example:- ColumnA---------ColumnB----------ColumnC 87----------------15-------------------20 10...
How do i make page #'s on top of pictures?
Hello, I am writing my dissertation and have just found, 5 days before the deadline that I cant put page numbers on top of images! Help! How do I do ...
Countif
Hello, I am adding a column to my excel sheet and would like to do an if statement. This is the statement I am trying to put into a formula . Identify...
Pc asking for a password?
Hello, everyone maybe someone can help? went to a mates pc to help this is what i found the pc boots to the black screen asking for a password (he n...
Macro problem!!!
Hello, Can anyone help me with the following problem I need to build a macro that can do these steps. step 1: the macro has to start when cell B...
Lost of password nd personal info
Hello,HI..I HAVE LOST MY PASSWORD ND FORGOTTEN MY PERSONAL INFO..BUT I REMEMBER THE YAHOO ID..AND SECUIRITY QUESTION,,WHICH I GAVE AT THE TIME OF MAKI...
Any one know about graphs on excel?
Hello, How on earth do you convert data from the new 2007 windows xp thing in to a normal bar graph. i need the x axis to say 'number of words in a ...
I can't browse any part of microsoftwebsite
Hello, I have problem with my browser, I can't open any part of microsoft website in spite of I can open other website. I have the same problem in fi...
I need help creating an excel formula
Hello, I work in Human Resources and need to create a formula for Personal Time Off. The employees accure PTO time at the rate of 0.46 per regular ...
Vista admin password forotten
Hello, I have been reading hese forums, but I have some more questions. I did the safe mode thing (as a limited user) and i either ave me an error or...
Matching help
Hello, I would like to compare three datasets. Each dataset consist of one column of I.D. numbers and one column of names. SO, I would like to matc...
Outlook issues
Hello, I was getting some problems with my outlook, the thing keep crashing and i can't read my mails. Any solution for this?
2 formula for 2 result
Hello, I am trying to write a formula in Excel that tells me how many times a text appears within a date range, i have managed to create the date r...
Ms office 2007
Hi, I'm unable to save my office document ? Whenever I tried to save "Closing Program" msg appears. I've uninstalled and reinstalled it twice bu...
