The discussions
Formula - if c2 is not blank, and b2 is blank, then copy c2 to
SolvedHi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...
Transfer data and then apply formula
SolvedHello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...
Copy formulas across workbook
Solved/ClosedHello, I want to copy Excel 2007 formulas from one workbook and past to the other workbook without the workbook name in the pasted formulas. Can ...
Macro to copy/paste specific range every 3 rows
SolvedHello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...
Need urgently to find a macro in excel report across sheets
SolvedHi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...
Error trying to populate new worksheet using macro
SolvedHey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...
Add string only if a text is present in a cell
SolvedHello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...
Copy cell from another sheet where cell is value...?
SolvedHi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...
Macro for filling data from specific cell to another
SolvedHi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...
Error: embedded excel spreadsheet
Solved/ClosedOccasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...
Lost basic11n.msi
SolvedHello, I cannot open MS Office Basic Edition 2003. I keep getting a message that says, "Missing BASIC11N.MSI file" I am missing the installer file. ...
Need to recover a pst file having a password.
SolvedHello, I am in need of a soft utility which can be used to change/ recover the password set on a pst file in outlook. I have a user who has forgo...
Transferring data automatically in same worksheet excel
SolvedHello, I'm finding a difficulty in transferring data from a number of cells to a table automatically. What I'm trying to accomplish here is that w...
Need value as per given criteria
SolvedHello, There is a range given on one column and on the other column there are points. Ex: 200 - 180. 10 points 179 - 160. 9.5 points 159...
Adobe reader could not open because it is either not a supported
SolvedHI i HAVE WINDOWS 7 AND WINDOWS XP AT OFFICE while opening one PDF file I am getting this error messege. Adobe Reader could not open because it is e...
If formula for a range almost works, except with blank cells
SolvedApologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....
Offline address book help for exchange 2007.
SolvedInstalled new copy of Exchange 2007. Keep getting following message: Offline address book definition is missing. Need help with this issue. Thanks.
Cannot browse - ftp ok, email ok, ping ok
SolvedHello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...
Date format
SolvedHello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
If condition formula required
SolvedHello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...
Excel consolidation tab
SolvedHi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...
If cell a1 has text then cell b2 has today's date
SolvedHello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...
Excel - repeat rows a specified number of times
Solved/ClosedHello, I'm aware of the post here https://ccm.net/apps-sites/software/1603-how-to-repeat-rows-a-specified-number-of-times-on-excel/ But I wo...
How to repeat rows by x number of times
SolvedHi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...
How to repair large outlook 2007 pst on windows 7
Solved/ClosedHello, User running Windows 7, with Outlook 2007, 20 GB PST. User has two email account, 1 may be an IMAP, 1 may be POP, or both can be POP (I'l...
Rounding function
SolvedHello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...
Vba to refresh all pivot tables
SolvedHello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...
Macro to add/remove rows based on highest # in group of cells
SolvedI am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....
Copy specific cells to separate worksheets upon 2 conditions
SolvedHello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...
Adobe reader error message at opening .pdf file
Solvedhello, I open my big .pdf file and Adobe Reader says: "The File is Corrupted or damaged hence cannot be opened". How to overcome such error mess...
Pdf file not open
Solvedi am getting the following error message when I open the pdffile "Adobe Reader could not open 'xxxx.pdf' because it is either not a supported file ...
Outlook archive file not opening
SolvedI have Outlook 2007 which has a 4Gb archive pst file stored on a file server, there are other archive pst's that I can open but this one wont,...
Copy certain cells when an option is selected
SolvedHello, Can anyone help me with a script to: Copy: cell A, Worksheet One to cell B, Worksheet Two; cell G, Worksheet One to cell D, Worksheet Tw...
Arrow key now working.
SolvedHi, When i use the arrow keys using excel, the columns & Rows are being highlighted. How to unlock this? Can you help me to solve this?
How i can open damaged pdf files?
SolvedI have an issue with trying to open old PDF files in Adobe Reader 9 Standard. The files were created in 2000 and they need to be retrieved to be put ...
Date format
SolvedHello, I want to write date into following format like (25/05/2015) into 25 days 05 months 2015 year. Is it possible??? Thanks Configuration...
Help to insert a date using a macro in excel
SolvedHello, I have a spread sheet with four tabs. I have written a macro to copy the tabs and rename them but I need to be able change the date which u...
Outlook 2007 corrupted .pst
SolvedMy Outlook 2007 cant open .pst file. IT appears file was corrupted. I ran scanpst, but it couldnt solve the issue. Does anyone know third party sof...
How to hide and unhide tabs according to cell criteria.
SolvedHello, I have an Invoice that has a Rent To Own Sheet and also an Order Form attached to it. On my the Order Form tab I have a data validation...
Excel vba format a range borders to crossed diagonal lines
SolvedHello, please help me to format a range of cells like if in a range a1:c10 if any cell eg: c1 contains a value c then format diagonal lines wit...
Outlook 2007 data file repeatedly corrupt
SolvedLooking for possible causes for corruption. Window 7 32 bit all updates, Office 2007 SP2 and all updates, POP3 mail account, 5.68 GB pst file, ...
Conditional formatting: 3 range of numbers
SolvedHello, would like to seek advice from some of the experts here. I want to do conditional formatting from column O6-O21. If percentage is a...
Reformatting a date in excel
SolvedHello, I could really use your help with Excel. How can I change a date formatted like this...03/12/2004...to just reflect the month and year...0...
Get a percentage in microsoft excel
Solved/ClosedHello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...
How to use name range..please help to solve this issue..
SolvedHello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...
Exam layout help
SolvedHello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...
Conditional formatting cell if every cell contains "yes"
SolvedHello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...
Compare 2 sheets -> summary differences
SolvedFor an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...
Conditional formatting for a particular column
SolvedHello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...
Copy & paste based on specific condition
SolvedPlease provide me the macro coding for the below scenario. I have four columns in my sheet 1 say Date,Name,Reference and Rate. When I am entering the...
