Office Software Forum
- Excel (9,723)
- Open Office (111)
- Outlook (635)
- PDF (334)
- PowerPoint (173)
- Word (2,181)
-
adding a day to the date [Closed]
I need a formula to add a day to the date. For example, today is Nov 22, 13; I want to add one day to have Nov 23, 13 in another cell. I saw a number ...
-
VBA Macro to calculate values in cell(s) from multiple sheets [Closed]
Greetings to the greatest trouble shooting team we have around, I am stuck in a situation where I have multiple sheets in a workbook, say this work...
-
Microsoft Publisher update [Closed]
Hi there Recently bought computer with windows 8. Have been using the Microsoft publisher and saved/back up my work. After a month when I now ope...
-
Macro for linking two workbooks, comparing one document ID with [Solved/Closed]
Hello, I need help in creating a macro for linking two workbooks, comparing document ID's in one workbook with the status of that Document ID's in ...
-
skip a value [Closed]
suppose a1 a2 a3 = john,michel, robert, respectively and b1,b2,b3=10,9,10 then from values of b cell i wanted to print name in g cell who have corres...
-
comparing multiple columns for list of items [Closed]
Dear experts I have list of names with multiple words in column A List of names with multiple words in column B List of names with multiple w...
-
Copying data on Macro Enabled Excel Sheet from Source File [Closed]
I am doing account reconciliation on a Macro enabled excel sheet for various funds. which performs some task through Macro on sheet, Now i want to ...
-
How to delete a line from Excel cell [Solved/Closed]
Dear all How to delete a line from every cell in a column??
-
Running a Macro permanently [Closed]
Hello, I have copied and edited a Macro to a workbook to save a certain cell as the file name. The problem is that you have to click on Macros fin...
-
2010 IF function help [Solved/Closed]
I'm looking to combine a IF function for one cell with a date function in another. The aim is to have something like this: =IF(A1=2099,"James Jones...
-
conditional statement [Closed]
i want to create a conditional statement to formulate below if A1=>0 then equal the value, then if it is blank then get the value or number from A2...
-
Need a cell value to change automatically based on a future date [Closed]
Hello, I need to submit weekly reports on the number of students in classes (currently enrolled, graduated, etc.) The problem I have is that sometime...
-
Iam trying a lot to make the formula succes, but its not helping [Solved/Closed]
Hello Ther!! Iam trying a lot to make the formula succes, but its not helping all people ther Kindly help me on the below formula it gives resu...
-
will i lose my apps if i reset my ipod touch? [Solved/Closed]
Hello, My sound does not work at all on my touch, ppl told me to reset my ipod, but im scared to lose all my apps. is there another way to get t...
-
Formula to move appropriate data to new sheet [Closed]
Hey everyone, I wanted to attach my spreadsheet but no such luck. Essentially, I have a spreadsheet with people's certifications. I have one col...
-
How can i transfer data in a row in a work book to another book [Closed]
Hi, I will be downloading data each day which consists 150 rows. Each row contains a data set pertaining to an individual item. Each of these ite...
-
finding a subset [Closed]
Please help me to find subset of A=(1-39). All subsets should be having six (6) numbers, e.g (1,2,3,4,5,6), (1,4,7,23,34,39), (2,8,9,21,29,30). Or hel...
-
Archiving an order [Closed]
Hello, Hi all, I wonder if anyone can help, I am trying to make a macro that will archive an invoice before the next order. Thanks for any help...
-
Link data with image [Closed]
Hello, I have C:\Photo folder with all jpeg images. All the names are unique and exactly matches with my product code number. In excel 2007 ...
-
Populate data from spreadsheet to spreadsheet [Closed]
Hello, Project Description: For daily customer orders, I need to be able to quickly and automatically have all rows in column D populated with t...
-
Conditional Formatting [Closed]
A B 226 215 80 127 0 0 226 215 80 127 229 234 206 206 211 233 19 217 220 231 20 232 21 134 32 224 51 227 above is my data. when ...
-
Automatically transfering data from one worksheet to another [Closed]
On excel is there any way you can get rows to move over automatically if their status changes?? So for example on a spreadsheet if you had a list of v...
-
Autofill of information from another worksheet [Closed]
Hi! I am currently making a report wherein I need for the information from another worksheet to be automatically inputted once the code is typed in...
-
Conditional Formatting analyzing the a range of cells [Closed]
Hello, I have an excel workbook with multiple tabs that contain many internal checks. Therefore, I created a "summary tab" that uses conditional ...
-
Merging two excel sheets [Closed]
Hello guys im totally new here and i want to ask a question. I have two excel sheets that i want to merge. Let me explain what i want to do and i ho...
-
Can't access Open Office or Documents [Solved/Closed]
I can't get the Open Office o4, to open. I have Vista, home ed. And I can't view the documents that are in the Open Office file. What if I dleted O...
-
Conditional formatting for a range [Closed]
Hi! I am working on a file where I have to format the cells in one column based on a list place in the same sheet in a different column. Basically...
-
duplication [Closed]
Hi, I a have a column A i.e names . for ex. 1 Row shailendra, 2 Row sailendra, 3 Row shylendra. above (3) names are same but spelling change now i...
-
Dating Problem! [Solved/Closed]
Hi Can you help? I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that sam...
-
Matching data from two spreadsheets [Closed]
I have 2 spreadwheets. One is a master equipment list with info stored according to Equipment #. The second is an invoice for equipment that is on th...
-
how to add a value to a cell if the other cell has text [Closed]
Hi, i am not able to find how to do the following formula in excel. what is the exact formula for: "if the value of the cell A2 is text then t...
-
Link image as per cell value : Complicated [Closed]
The explanation of the required details is in the attached sheet itself http://speedy.sh/M5SHA/Images.xlsm regards Pooja
-
Hide/Unhide an Autoshape or Picture in Excel [Solved/Closed]
Hi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, an...
-
conditional formatting of a cell if another cell is blank [Closed]
Hello, All i am challenged in resolving the following problem I have and am hopefull that someone can help in Column E I have specific text "tier ...
-
trying to copy data from one sheet to another and rearrange [Closed]
I have an Excel sheet, and I need to clean the data and copy it to another sheet. The cells change by 11 between records. I tried creating the initial...
-
conditional formatting if a cell is blank and other has value [Closed]
Hello, in Column E i have specific text "tier 2" or "Tier 1" i would like to format the color column L if Column E = Tier 2 and the value in the cor...
-
Need to copy a whole sheet into another [Closed]
Working with 2 sheets, one as the invoice and the second as the master record. Everything entered into the invoice will be automatically copied into t...
-
My letters type all over the place or not at all [Closed]
Hi, My letters type all over the place or not at all. Help. Thank youin advance
-
Excel count sheets in a workbook [Closed]
how to count the no of sheets in my workbook, like a list or whatever, also get the sheet name against it,
-
excel how to change to value [Closed]
Please help me to change this data which is highlighted in Yellow color to the other cell in values.. i cannot do any calculations on it...
-
Excel if statement using time [Closed]
Hello, I am trying to do some conditional formatting using if statement. I have a spreadsheet that is supposed to flag targets based on a 24hr clo...
-
Nested And/IF Statments [Solved/Closed]
Hello and good day. I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a comple...
-
Excel worksheet auto generator [Solved/Closed]
Hello, i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee wil...
-
Unable to send Mails [Closed]
Dear Administrator, Hi, Wishes for the day. My name is santhosh and am facing a problem with outlook for the first time. As i cannot send the e...
-
conversion of excel files to dbf files [Closed]
need to convert excel (win 7) to dbf what software options are available
-
Formula to count if cells in consecutive columns are populated [Closed]
Hello, I need an equation that will return a 1 in column F if data is available (cell is populated) in 2013 or last two years (2012 & 2013) or las...
-
Need help with lookup? or if? command [Solved/Closed]
Hi Everyone, Can someone help me with a command or macro that will look up the price of a product in a country from a reference worksheet and then fi...
-
formula needed. [Closed]
Hi dear i am looking for an formula that can resolve the following issue. I have a table of: Actual...............................................
-
Compare cells of two columns excel 2007 [Solved/Closed]
Hello, I have two columns with identical cells and I need to find those that are not the same. For example: Column1 Cell1 = "a", Column2 Cell1 = "...
-
cap-locks [Closed]
Hello, Is there a way to make a spreadsheet only type in all caps? Configuration: Windows 7 / Internet Explorer 10.0
