Office Software Forum
- Excel (9,735)
- Open Office (113)
- Outlook (637)
- PDF (334)
- PowerPoint (174)
- Word (2,183)
-
Resize the range [Solved/Closed]
Greetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while usin...
-
how to compare data btw 2 sheets and identify the difference [Closed]
How to compare all info in sheet 1 and 2 and identify the difference SHEET 1 COL A COL B COL C COL D GF123 USD ...
-
Macro to Cut and Paste into next available row in another sheet [Closed]
Hello, I am very new to Macros and I am trying to write one that will cut the data in cells F3:H13 on sheet 1 and paste them in the next available...
-
Comparing Two Sheets in Excel to Eliminate Date [Closed]
I have two lists in excel, one is a full list of data and one is the list of data that I need to eliminate from the first. How do I compare the two li...
-
If formula [Closed]
Hello, I have to keep track of utility bills for my company on a month to month basis; is there an "if" formula that I could use to alert me if I have...
-
Excel 2013 Macro [Closed]
Holà! I am currently using this macro created by a former coworker to create & save as, a couple dozen excel workbooks. (This is just a section to...
-
Using the IF function for dates [Solved/Closed]
Hello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...
-
Number Conversion to Code [Closed]
Hello, Hello, I appreciate any and all who may give this issue some consideration. This is to change a number to a code of letters to hide ...
-
How do I code using a cell.? [Closed]
I want to make a code that takes a phrase such as "hello" and change each letter to a number so it's says something like "50,41,62,62,60" how do I do ...
-
How do I code using a cell? [Closed]
I want to make a code that takes a phrase such as "hello" and change each letter to a number so it's says something like "50,41,62,62,60" how do I do ...
-
Look at two different cells, refer to a 3rd, return value in 4th [Closed]
Hello, I am working on a worksheet and want to return a value from a column entitled "Possible Points" depending on which column is checked, "...
-
Create a Table from data held in an existing table conditionally [Closed]
Hello, We have a job monitoring excel we have been using where we have an existing table that holds the status of all possible jobs we are investi...
-
outlook can receive mail but can't send mail [Solved/Closed]
Hello, I have a friend who is suddenly unable to send emails. But he Can receive, however. Error Message is "unknown error" Ox800CCC13 windows 10 ...
-
Data entry [Closed]
Hello, i am working on two different excel sheets. in sheet 1 i have a similar types of entry suppose that students name of same student mult...
-
How to Separate the worksheet based on data [Closed]
Dear Sir. I had the data as mentioned below for your reference CODE EMPNAME EB HRA GROSS 175702 MAURICE J P 10,140...
-
copy data without opening workbook using vbscript [Closed]
Hello all, Is it possible to copy data without opening workbooks using vbscript? Thanks in Advance!
-
Use certain words in two different cells to determine rate [Closed]
Hello, If cell A2 is word "Beachwalk" and cell B2 is word "hskp" i would like that cell C2 shows rate $13. Would like to make a formula that all c...
-
help writing a IF formula [Solved/Closed]
Hello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works IF(A2=''receive'',1,2);...
-
If a cell in column contains "x", return the value [Closed]
Basically I have a large spreadsheet and I want to pick out the values that I flag with an X. Not all of the rows have an x next to it, but the ones t...
-
If statement formula [Closed]
I have to keep track of utility bills for my company on a month to month basis; is there an "if" formula that I could use to alert me if I have not re...
-
Inserting multiple images based on cell value [Closed]
Hello, I hope to find some help here as I would really like to find an easier way than just insert each picture manually. I have range of cells va...
-
Formulas to Pull out text in Description [Closed]
Hello, I need a formula that will produce the following results: Actual: A1. Cash 10/2/15 A2. CC Application 10/4/15 A3. Check 10/17/15 Kn...
-
comparing changing data in 5 excel sheets [Closed]
Hello, I have a daily spreadsheet that I need to compare to the previous day and so on for the wk. In line A i have a list of products,in line B t...
-
free pdf to excel converter [Closed]
please is there anyone that can share a free pdf to excel converter? thanks
-
Excel column comparision. [Closed]
Hey, I want to compare two tabs in separate columns with data which gives a match (Its okay if not exact) even though the words are jumbled or same. S...
-
Excel column comparision [Closed]
Hey, I want to compare two tabs in separate columns with data which gives a match (Its okay if not exact) even though the words are jumbled or same. S...
-
Adobe Acrobat in German NEED English [Closed]
How can I change the language from German to English, if I cant read German? Can someone show me with the tabs? I have tried translating each word on ...
-
help with a formula [Solved/Closed]
Please help !! Looking to calculate totals based on the following... Entering the formula in the following field K4 I have rows (B4 thru B18) e...
-
Formula to add 1 with IF statement [Solved/Closed]
Hi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...
-
formula issues with various variables [Closed]
Hello, I appreciate the time the forum are taking to view my message. I'd very much appreciate it if someone could help me, as I'm trying to make ...
-
MS OFFICE 2007 work on windows 7 ultimate or not [Closed]
Hello, ms office 2007 enterprise work on windows 7 ultimate or not ? please reply ...... Configuration: Windows / Firefox 29.0
-
Transfer data automatically from one sheet to other based in [Closed]
Title->Transfer data automatically from one sheet to other based in specific dates. Hello and sory for my long title. How can transfer data from a c...
-
Comparing two excel files of office 2010 [Closed]
Hi there I have two excel files. I am using office 2010 professional. Each file contains 15000 rows and 10 columns. I need to compare the both files....
-
copy content from excel to another excel using command prompt [Closed]
Hello, Is it possible to copy content from one workbook to another workbook using command prompt. say, I have 2 excel named a1 and b2. I would ...
-
Use macro enabled workbook in macro enabled excel template [Closed]
Greetings, Is it possible to use macro enabled workbook inside macro enabled excel template? (i.e,) sample1.xlsm is the macro enabled workbo...
-
How to Copy/Insert a worksheet, rename and populate with data [Closed]
Hello, I am new to writing macros in Excel. I want to automate the following tasks in an Excel workbook, using the following: 1. "Summary Sheet" ...
-
Forgot cyber cafe pro's admin username and password [Solved/Closed]
please can somebody help me. after installing cyber cafe pro 5 for just 4 machines, I completely forgot the admin username and so I decided to unins...
-
how to remove mark up area in microsoft word 2007 [Solved/Closed]
Hello, How to remove mark up area in word file Configuration: Windows 7 / Firefox 29.0
-
Updating Existing Worksheet [Closed]
Hello, everyone I hope everyone's holiday's are great. I want to thank everyone in advance for their help with this situation I am having in excel. ...
-
Figure Out Error [Closed]
Hello, I would like to solve this error in the given code which is I can't able to figure out what and where it has an error. The issue is th...
-
Not Pasting values in Excel file [Solved/Closed]
Hello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no merging...
-
Translate or Convert Text in Excel to Consolidated Numbers [Closed]
Hello, I am quite new to Visual Basic for Applications, but I am trying to figure out if a specific part of what I am trying is possible/how to go...
-
AutoFill data from list [Closed]
Good evening, can i have your help please? In the sheet "ΟΧΗΜΑΤΑ" i have a range D5:AG5 which are the titles of 30 columns. In area D6:AG35 i have n...
-
Sort [Closed]
Hello, On Column A I have DATES Column B a code (D1111, D2222) Column C Vendor num Column D Client num I want to be able to identify when f...
-
Coping formulas to next row using a macro [Solved/Closed]
Hello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. I...
-
VBA Code [Closed]
I dont know how but I managed to put together a macro that copies transposed info entered in a column of one sheet to a row in another sheet. The prob...
-
Restriction of @ and .com [Closed]
Hello, Thank you for your reply, I have another question, if you can help me with that too? I want to add a restriction in a column for suppose C co...
-
Compare data in two excel sheets [Closed]
Hello, I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and find...
-
Excel sheet alphabet count [Closed]
Hello, How can I count alphabet on excel sheet. kindly send me the details Thanks & regards Pulakesh Medhi
-
Subtraction total [Closed]
Good evening, please anyone who can help me, i have in cell J5 all products eg. 20 parts. In cells L5:W5 add how many parts i have used. How i will ...
