The discussions
If one cell contains a name then?..help.help.
SolvedHello, I have a 2 columns in (Worksheet 1) . One with Names (A1) and the other with Numbers (B1) corresponding to the names. On (Worksheet 2) (C1...
Filtering problems
SolvedHello, I have a microsoft database access and I'm trying to filter some records. This is what I do: 1. I have a form for query purposes, in tha...
Macro: watch a cell and copy if changed
SolvedHello, The problem in a nutshell is that I have 5 pivot tables on one worksheet, each with a field called "date" above the main text. Each day the...
Create a macro to format a column
SolvedGreetings, I am not a programmer but I know how to create basic macros that would perform simple repeated tasks in a fixed range within a sheet. ...
Macro to delete duplicate items -help please
SolvedHello, I'm trying to create a macro to delete the row that has a word at the biginnig and the same word at the end. Example: MIA/SFO/MIA ...
Technics to unlock administrative passwords
SolvedHello, Can you help by showing me how to unlock a computers with an administrative passwords if theres no unlocking software? Configuration: Wi...
Sum with conditions but look at date
SolvedHello, I want to sum the conditions in a certain month. Say for June from the 1st to30th or July 1 to 31. The formula that is used without the date ...
Word - print preview vs page location
SolvedHello, I like to edit my documents in Print Preview, and at 100% zoom. However, when I do that the page is being displayed on the left hand side ...
Help to adjust this code slightly!
SolvedHello, I have this code, Sub IMPORT() Dim NextRow As Long Sheets("New & Renewals").Range("A4:D4").Copy NextRow = Sheets(...
To get password of g-five u-909
SolvedHello, i have forgten my security or password of my mobile so how can I open the my mobile. please help me Configuration: Windows XP / Internet...
Textbox date value max
SolvedHello, My english is not good so sorry in advance need to get the maximum and minimum value of date in excel userform . i m use these code ...
Formula help
SolvedHello, I need a formula to calculate overtime. I have this spredsheet that tracks everyones time, a regular day is 8 hours, anything above that is...
Forgotten its password
SolvedHello, Hello, i have21GB micro sd card & i have forgotten its password now it is blocked so help me in opening Configuration: Windows XP / ...
Excel, filling in cell values automatically
SolvedHello, I have two worksheets in Excel 2007 and am trying to automatically fill in cells in worksheet two based on values in the first worksheet. A...
Text help in excel
SolvedHello, i need to get 2 text cells on sheet 1 to list in 1 cell on page 2 any help would be cool with me since i am new to this neet thing called e...
Lessthan or =,greater than and sum
SolvedHello, I have the following values in Excel 2007: A1(38)B1(26)C1(20)D1(80)E1(75)F1(50)G1(3) In H1 the formula =IF(AND(A1=C1,D1>E1,SUMPRODUCT(F1-G1)...
Web cam problem
SolvedHello, web cam of my note book doesnt work where i have to download free driver for webcam Configuration: Windows 7 / Internet Explorer ...
One cell two formulas
SolvedI have a cell that can change from "USD" to "PESO". When this cell is changed i need another cell to calculate appropriately. I have these two formula...
Vlookup in other worksheet (date)
SolvedHello, Attached please find the reference file. https://authentification.site/files/23765947/sort.xls I am doing a VLOOKUP from sheet 1 to she...
Vlookup tool
SolvedHello, Configuration: Windows XP / Internet Explorer 8.0 I am using Excel2003.Plz let me know how can i use vlookup tool. Step by step met...
Help with excel please
SolvedHi I have an excel spreadsheet with two columns in A is a list of codes, and in B a list of names containing the codes in a string A ...
Copy entry from each worksheet to new sheet
SolvedHello friends, After reading some very useful suggestions. I thought of posting my problem, hoping i'll find a solution I have a workbook which...
My new computer does not recognize my printer
SolvedHello, I just bought a new computer with Wndows Vista. I have a HP Laserjet 1200 seires printer that my computer cannot seem to recognize. The pr...
Administrator password in ragistray
SolvedHello, dear all pls tele mi wich location save the administrator password or user password in ragistry
Excel absolute reference?
SolvedHello, Configuration: Windows XP / Firefox 3.6.7 I have cells A1:A5 as "5, 10, 15, 20, 25" respectively. I want to make cells C1:G1, ref...
To find the max value +
SolvedHello, Hi need to get the maximum value for certain range of cells. and the value of the cell next to that max cell. can any one help ...
Browsers all stop. router is fine.
Solved/ClosedHello, Recently, without installing any new software, my browsers all eventually stop. Firefox is my main, and would be the first to fall after abo...
Data validation formula
SolvedHello, I have a spread sheet that tracks attendance. What i want to do is to alert the user whenever 3 OR MORE CELLS IN SEQUENCE CONTAIN THE SAME D...
Find last time text entered and return value
SolvedHello, I've got text in column D and a value for it in column G. I want to lookup/find the last time "Bolt 'was entered and return it's value.(the...
Copy and paste to other file.
SolvedHello, Can anyone tell me what's wrong with this code? I record it using macro.. Columns("G:M").Select Selection.Copy Workbooks.Open ...
Vlookup according to location not name
SolvedHello, i put the name of the files i want to perform in some cells and wrote a maco for excel to call up the file according to the location. (lets s...
Help with a conditional macro?
SolvedHello, I am trying to use VBA to check whether an M appears in column B and then, if it does, paste the information from that row (Columns A thr...
Go to next page in word doc using vba code
Solved/ClosedHello, Can any one tell me how go to next page in microsoft word doc using Excel Vba + macro code
Outlook connect to your incoming (pop3)
SolvedHello, At the time of setting my email account in indiatimes the following error showing sending & revived box.plz suggest Task 'umakanta200...
Copy rows until meet given line
SolvedHello, I'm trying to split one spreadsheet into several spreadsheets. The splitting has to be done when a certain value is found. I need to mo...
Ms office 2003 product key
SolvedHello, i am rajesh i want to install the ms office 2003 but i have no product key please arrange the product key Configuration: Windows ...
Forgot my corby password
SolvedHello, i had a password for phonebook and messages ..i reset the password anforgot..now how will i unlock it?? Configuration: Windows Vista / F...
Insert 2 rows, copy the formula.vba help pls
SolvedHello, I have a huge file to work on. Please help me with a VBA that does the following for the entire sheet (until the last row) 1) Whenever y...
Changing font colour
SolvedHi, I've looked at some posts on your site and followed the advice, however I can't get this to work. I'd like to change the font colour of a range ...
Do not count if date not entered
SolvedHello, I have a date in C3(30/06/2010) and sometimes a date in C4 (01/02/2010).In C5 i got a formula =((C3-C4)-I3)+1)*24. I3 will have the amount ...
Found and paste
SolvedHello, i have two files, one is excel which contains few articles like 111230, 111412, 552136 etc and other file is notepad which contains hundreds o...
Vba macro-move to cell underneath the button
SolvedHello, I want my VBA macro to move to the cell 'underneath' the particular button that is being pressed. (I have a series of buttons down the page, e...
Forgot my login password
SolvedHello, Configuration: Mac OS X / Safari 531.22.7i can not get in to my laptop it is a dell forgot my login password
Width & merge cells
SolvedHello, I Have 1 WorkSheet In Which There Are Too Many Sub Sheets. I Want The Width & Merge Cells Of Sheet1 In To All Sheets. But I Dont Need The ...
Matching 2 columns in excel
SolvedHello, I've got 2 columns of data- I'm trying to see if there's a match between the data in Column A with Column B- if the data is in Column B somewhe...
How to convert a numeric value into english w
SolvedHello, How to convert a numeric value into English words in Excel plz show that formula regards Ravi
Dell latitude d630 administrator pasword
SolvedHello, i have a laptop latitude d630 with an administrator pasword please help me. Configuration: Windows XP / Internet Explorer 6.0
How to use text value in cell as criteria
Solvedhello, In cell D1, I'm using a SUMIF formula like so =sum if (A:A; criteria; B:B). In Column A and B is a list of charges different companie...
Coloring the last 3 dates in a range of date
SolvedHello, In my last post, i mentioned about coloring the last 3 dates in a range of date in blue, and the rest in yellow. I used this code as to do t...
Memory card password
SolvedHello, i forgot my memory card password, i format it twice now i am battling for getting password. Configuration: Windows 7 / Safari 533.4
