Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Take Reference from previous sheet automatically Closed
Hello, I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i...
-
allow my outgoing mail Closed
Hello, I have tried 465 and 587 and 25 all do not allow my outgoing mail can some help me with my problem
-
Auto fill columns Closed
Hi, Just new to Excel. I recorded a macro to paste column names in a formatted table and want the formula in first cell to be applied automatical...
-
Excel - To generate unique ID Solved
Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...
-
decrease the value first by 10% and then increase the value by 5 Closed
I want to decrease the value first by 10% and then increase the value by 5%. What is the formula in Ms excel.
-
security code Closed
Hello, Please consider using the below codes in order to have the phone restored to factory settings and hence get the present difficulty expe...
-
I need a macro please Solved/Closed
Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...
-
trying to base format on date in cells Closed
Good morning all, I have a worksheet that formats the cell containing the last date an item was issued when it is within 30, 60 or 90 days of ...
-
Want to add to Excel Macro, unsure how to do what I want Closed
Hello, I have the following Excel Macro that counts the amount of times a specific campaign value is present in a column. I would like to add on to th...
-
Excel using date range and formula on separate sheets Closed
I'm creating a bank register with the dates in column A. Values are in columns C and D. The title of my first page is 'Register' What I'm trying ...
-
Copy daily cost entries into the particular ledgers Solved/Closed
Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...
-
Brijesh Parmar Closed
Hello, how to count job dates for in column if dates are repeated. report no Date 5462 21.12.14 5463 22.12.14 10134 21.12.14 20354 22.12.14...
-
Need MSExcel 2007 Formula Closed
Hello, Masters of Excel. I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief. T...
-
Change General data into date format Closed
Hello, I have a date format in excel like 28/04/2014 00:00:00. I am unable to convert into date format. if i enter formula like date(A1) it is s...
-
Excel cell equal another cell only if its a certain percentage Closed
Hello, I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its ...
-
Excel 2010 format rows with a related cells rule based formattin Closed
I have a worksheet that formats the cell containing the last date an item was issued when it is within 30, 60 or 90 days of the annual issue date. Ho...
-
I need help, a macro that will filter, copy, and then paste. Closed
Hello, Hi there, thank you for opening this. I really need some help. I began working at a hotel and lets just say that they need some help. I've ...
-
A macro to copy data into new worksheets Closed
Hello, I am looking to write a macro to copy information in rows, and paste them into new worksheets by columns e.g DataSheet: Name¦ Country¦ City...
-
Lock a Cell in conditional formatting Closed
Hello, is that possible to lock a cell in conditional formatting. for example: if B4=END then lock A4 Cell thank you it will helps.
-
Excel Macro for gathering data at one place Closed
Hello, I want to make a marco that copies the data from no. of workbooks which also contain no. of worksheets and gather all that data in one work...
-
date Entry Solved/Closed
Hello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he shou...
-
How to Lock or password protected specific cell in excel 2010 Solved/Closed
Dear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. Pleas...
-
Checking Cell Value against a Range of Numbers Closed
Hello, I want to check a cell's value and if it falls in a particular range then I want to write "OK" in some other cell and if it falls out of sp...
-
Help with macro in excel Closed
Hi I need some help in writing a macro for the below: 1. In sheet 1, I have column A with a list of items and many of them will be repetitive, ...
-
date change in excel sheet Closed
Hello, in excel sheet date come to 29/12/2014 now i wants date on 29/12/14. so help me how to change date format or use formula to change date fr...
-
Compare excel data Closed
Hello, In excel i have say the following coordinate data: 2792691.388 215476.765 423.165 2792691.388 215526.765 423.045 2792691.388 215576.765 ...
-
Excel macro to format report Solved/Closed
Hi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of submit..........
-
Excel function I cant figure out Closed
Hello, is this possible below? so A2 & A4 are the numbers I want ti time by 50% and only if B2 & B4 are equal or greater then 54%, so row "A" should e...
-
Excel File is corrupt. Closed
I hope one of the experts here will be able to save the files, which are very necessary for my work. My excel file became corrupt for very obvious rea...
-
how to format a cell based on date in another cell. Closed
Hello, i.e. We want to format B1 based on date in A1. ( If date in B1 is 2 or more days higher from the date in A1, then B1 must get colored. This...
-
look through each sheet and copy and paste to another workbook Closed
Hello, Dear Sir Would you know how to copy from row 2 to row 20,000 in sheet 1 to sheet 10 in one workbook and paste to corresponding sheet 1 t...
-
Conditional Formatting importing data from website into Cell A1 Closed
Hi I am importing data from a website into Cell A1. The data is a numerical value. I want the Cell's background colour to change depending o...
-
How to Create a Dependent Dropdown List in Excel Closed
Dependent dropdown list is something that keeps-on changing its items based on a change in the value of another dropdown. Execute the following st...
-
dropdowns in excel Closed
There are multiple ways in which you can create a dropdown list in Excel. Data Validation Form Control (Combo Box) ActiveX Control (Combo Box) But...
-
Conditional formatting based on dates Closed
Massive long shot here.....I'm trying to conditionally format certain cells to black out after the end of a certain month. It is for a monthly time...
-
move completed data in sheet 2 Closed
Hello, I have raw data in sheet 1. I need to move completed data in sheet 2. I m using column H to update work status as "completed or pending". Pls...
-
Excel VBA - Color Code Column cells based on values Closed
Hi, Super new to VBA, and need to write code to evaluate the values in Column I, starting with I3 and going down a varying number of rows depending...
-
How do I change the format "YY/MM/DD" to show as "MM/DD/YY"? Closed
Hello, I have a spreadsheet that I need to convert the date fields from the format "YY/MM/DD" to read as "MM/DD/YY". For example, if the field c...
-
Need to write a macro to copy a row of information if true Solved/Closed
Hi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...
-
typing master question Closed
is in this application full study can be done.....?
-
VLookup Closed
Hello, I have a spreadsheet with column headings, Project Manager, Project Cost Engineer, and Project Schedule Representative. Once I key in th...
-
VBA cut/paste in another tab Closed
Dear all, I'm trying to copy in a different tab all rows that indicate in column [AN] a value less to or equal to 12. However, this column, as i...
-
Transfer Data from a sheet to another many sheets Closed
Hello, I am trying to transfer data from one sheet to many other sheets . For example , when I write data to a row , I woul...
-
outlook pst fix Closed
Hello, I have MS Outlook 2007. I recently had a problem with my computer, where when Outlook starts up, a message pops up saying "Cyclic Redundanc...
-
every time copy and paste to master excel sheet one by one Closed
Good morning, Am working at Food Product Company in Quality Section . i received so many mails from depot Product complaint details in excel sheet...
-
Assistance with Excel macros Closed
Greetings all My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to...
-
Automatic duplication of info to sheet 2 for ordering form Closed
Hello, Configuration: Windows 7 / Chrome 39.0.2171.95 I'd like to know if anyone on this board could help me or direct me to where I can fi...
-
Text label and value if value in other worksheet is > 0 Closed
can anyone help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label based on witch c...
-
Conditional Formatting a row from a validation list Closed
Hello, OK, I am trying to apply a conditional format to a worksheet whereas I have a validation list in a column at the end of the row of data. Ba...
-
Excel-Macro to sumup data from multiple workbooks to Master xlsx Closed
Hi All, Can you please help me. Scenario: 1. There is a common template which has some tasks listed in columns against which the team members wil...