Office Software Forum
- Excel (9,733)
- Open Office (113)
- Outlook (635)
- PDF (334)
- PowerPoint (174)
- Word (2,183)
-
memory card password recovery [Solved/Closed]
Hello, i have nokia 5130 expressmusic mobile phone with 2 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the...
-
how to copy and paste the value corresponding to the matched cel [Closed]
Hello, A COLUMN CONTAINS VALUES 2, 3, 1, 10. B COLUMN CONTAINS VALUES 22, 1, 2, 36, 24, 10. C COLUMN CONTAINS VALUES 9, 8, 7, 6, 5, 4, 2, 1. NOW...
-
Copy a row based on a cell value. [Closed]
Hello, I have a very large spread sheet that I am trying to sort on to new tabs. Example tab one has the data and column A is the sorting column t...
-
Filter multiple worksheets based on data input in a master works [Closed]
Hi, I need some help with creating a VBA. I have a workbook that contains 6 worksheets. The first worksheet is a summary of the data listed in the...
-
trying to print an attachment [Closed]
I have an e-mail that has an attachment that is typed in Word. I have just installed Office 365 on my laptop which has Windows 10. When I click on...
-
Copy\paste [Closed]
Hello, Please help with below query Have 2 worksheets in same workbook and below macro is extracting data from other sheet based on firstname a...
-
Creating macro to search two values and delete them [Closed]
Hello, I´m new here. but I´ll try to do my best. I am looking for a macro where I can search in the column "I" all the values between two value...
-
Auto transfer from one tab to another [Closed]
Hello, I have been looking for ways on how to transfer a data in gdoc sheet from another tab. Example.. From Original File all data for ca...
-
Verifing-Vin Numbers [Solved/Closed]
Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...
-
formula [Closed]
I have multiple rows and one field is called product and the other is color. I am trying to figure out one formula that can be used on all the cells. ...
-
macro to search 2 values in a colum and delete them [Closed]
hi friends I´m new here. but I´m trying to make a macro where I can search in the column "I" all the values between two values. Those values are loc...
-
convert 4012016 and 24012016 in date format [Closed]
dear sir how we convert 4012016 and 24012016 in date format as dd/mm/yyyy in excel.
-
office error [Closed]
Hello, ms office word opens with squared boxes in back ground instead of blank page HOW TO RECTIFY TO BLANK PAGES
-
Dates from an IF statement [Closed]
Hello, I ve selected some dates via a simple if statement and can see the dates in the cell where I want them. But when I try to use them in anoth...
-
.xlsx, xls file [Closed]
Hi, I am not able to open the MS Excel file i receive in xlsx or xls format.How can i open it ? Thanks, Manwendra
-
Macro auto fill is not working [Closed]
Hi all I am trying to write for my excel .I am begginer and this first time I tred Macro. I wrote this code Private Sub Worksheet_Change(ByVa...
-
Weekly Totals [Closed]
Hello, I have a column of dates and a column of transactions. Often there are multiple transactions on the same day. How can I enter a formula in ...
-
To find a word in a sentence columnwise [Closed]
Hello, I am trying to find a particular word in a set of sentences columnwise. For example cells A1:A100 has the sentences and cell B1:B20 has the...
-
Counting a text Range if another text range has a value of.... [Closed]
Hi Everyone... Finding this really hard to figure out... I have Cell A1:A50 Containing lots of names And I have Cells C1:C50 Containing the Statu...
-
Modify the Macro [Closed]
Hello, I would like to request please modify the below macro. The below macro create a line (shape), in all sheets. If it once created (or it a...
-
If date exists (or any value) in B2, return value of 1 to C2 [Closed]
Hello, If for example there is a value of a date in column B (Row b2 or other) I need it to return a value of 1 in column C (C2 and corresponding)...
-
using formula for conditional formatting [Closed]
Hello, Excel 2013 I need to add an if formula that creates conditional formatting and I get the basics of it but my formula is not working It's ...
-
Need to know the excel macro [Closed]
Hello, I have a data like this which I would like to know the macro function. Row column A 1 123 2 456 3 789 Am curr...
-
Excel False cell [Closed]
Hello, I need help removing the FALSE statement in the cell? =IF(N14=TRUE,CONCATENATE("Need a copy of the Trust Agreement"," If the trust i...
-
formula that searches in a row for a cell/column that contains [Solved/Closed]
Hi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...
-
convert pdf file [Closed]
how i convert pdf file in excel file is in marathi language
-
Removing a returned value of FALSE in Excel [Closed]
Hello, Here is my formula. Please tell me how I can eliminate the FALSE value for cells that don't fall within the date range (e.g. cells with dat...
-
Cannot sent or receive messages windows 7 [Closed]
Good day We trying to sent and receive emails but cannot do that can you help us please outlook Thanks Configuration: Windows / Mozilla ...
-
Verifying VIN [Closed]
I have two Excel Worksheets, ie, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to compare and confi...
-
Auto populate based on matched data from other sheet [Closed]
hi, Newbie here.. Was wondering if this could be achieved thru vba as have tried using formulas and vlookup thru matching criteria and it takes fore...
-
Error in VBA [Solved/Closed]
Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...
-
Automatically transfer data from one sheet to another [Closed]
Hello, I have never done anything like this and i just watched a video that got me the first two correct columns in the second sheet but i am unable...
-
Macro Help - Pasting [Closed]
I am trying to write a macro for updating workbooks for of my accounts. Basically I have a master sheet of some data for all accounts and need to copy...
-
Extracting data from sheets added everyhour [Closed]
is there a way to extract data from sheets i add? like if i have data from multiple hours but i put all the data in one book but in different hours is...
-
Macro within Open Office Calc [Closed]
I am having trouble with making a code do what I want. I am trying to get a workbook with multiple sheets working in this way. if I have a main sheet ...
-
Replace function in Macro [Solved/Closed]
Hello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...
-
VBA copy based on list to specific directory. [Closed]
Hi, I am attempting to copy a file with names from an excel list and copy them to a specific directory using VBA. I am using rizvisa1's code from http...
-
Securing a Excel Workbook [Solved/Closed]
Hey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...
-
Copying function using VBA [Solved/Closed]
Hello, I have a Problem that desperately Needs to be fixed: I am trying to create a Participant List, and in order to Keep it "clean", am using ...
-
Compare 2 columns on 2 sheets for value of cell [Closed]
I have tried several different formulas and cannot seem to get it right. I have a work book with 2 sheets. I am trying to populate column E of she...
-
how to recover previous version of an excel file already saved [Closed]
Hello, how to recover previous version of an excel file already saved Configuration: Windows 7 / Mozilla 11.0
-
Copying number over from last sheet and adding to it [Closed]
Hello, I'm trying to figure to if it's possible to do the following: I have an excel doc with monthly spreadsheets and I would like a number to be...
-
tranfering of data [Closed]
how do i add symbol in cells in sheet 2 if there is data in cells in sheet 1. example: i have data in A2 in sheet one. i want to add a * in A2 in shee...
-
Extract rows of data and paste to new worksheets based on locati [Closed]
Hello Fellow Excel Users: Please help if you can. I have a difficult problem that I hope someone could please help me with. I have a worksheet of...
-
Office Home and Student Excel [Closed]
I have read everything. Been asked to submit my first question three times. This doesn't bode well. Third time typing same question. I have used exc...
-
Macro that will delete rows based on greater than current date [Closed]
Hello, I want a macro that will delete rows that are greater that the current date so if today is 2016-05-05 I want it delete all rows with somethin...
-
copy the number matched to another column [Closed]
Hello, I want help from world.i want to copy the list of number to other column which are match in original column. Start no 974314567 copy the ...
-
VB & pdf files [Closed]
Hello, Overall goal to open pdf files, copy information to excel sheets & close pdf files. From reading material on web it might be easier to conv...
-
How to watermark PDF online? [Closed]
Hello, How to watermark PDF online without the need to install any software? Configuration: Windows 7 / Chrome 50.0.2661.87
-
Excel 2010 - "file is corrupt and cannot be opened" [Closed]
Hello, We're upgrading to Office 2010 and having some fun issues with old and new .xls files. Current issue is that many .xls files (as opposed...
