Office Software Forum
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
How to transpose and move data Closed
Hello, Have a data set which is 2 columns and 596 rows, in which I need to transpose parts of the data set, remove empty columns, and then line up...
-
conditional data display depending on a dropdown list Closed
Hello, I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list. For example, if my dropdown...
-
Create new workbook copying data from 2 sheets in same workbook Closed
I want to copy the basic name and customer info from 1 sheet and create a new workbook with that customer's name as part of the file (and copy several...
-
IF Formula Query Closed
Hi there, I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the...
-
Data consolidation Closed
Dears Need your expertise advice. I have an excel data in below format , need a formula Column 1 has text like ABA, ABA , ABB, ABC, ABC, ABC . ...
-
How to create a macro to update a file based on a masterfile Closed
Hi I would like to create a macro (program) which will update a file by clicking on a button, based on a masterfile. Basically I have a list of ...
-
Transferring data Closed
Hi, I use excel 2007 version. I have some data in an excel sheet - students' names, ids, test items attempted, multiple attempts made by each st...
-
Transfering data for a spreadsheet to another Closed
Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.
-
Conditional format only if different from cell in another sheet Closed
Hello. I am using Excel 2011 on a Mac. I have two sheets in my worksheet. Both sheets are a two week schedule. Sheet 1 is titled PP - it is the ...
-
auto-copy cells one to another + formation too Closed
Hi! I want to make intelligent excel, like.. i have many sheets and i want it to work the way, that sheet2 takes data from sheet1. so 1) ...
-
set a conditional formatting to highlight the latest number Closed
I have a column to record invoice numbers in this formatting KI-00123 where the number portion is in running order. How do i set a conditional formatt...
-
Strike through when entering date Solved/Closed
Hello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...
-
Place new Code to Working Code Solved/Closed
Hello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...
-
Printing Selected Columns from Multiple Sheets Closed
Good day, I recently made a workbook with multiple sheets. I am a newbie regarding Excel. I would like to know if there is a way for me to have ...
-
How To Apply Conditional Formatting in Excel Solved/Closed
Hello, I need to apply conditional formatting to range H1:H10000 based on corresponding values in another column, G1:G10000. If the value in t...
-
Copying a row to a different worksheets depending on word Closed
Active Worksheet is called Quote Sheet Row A has a drop down list: Booked Missed ...
-
If Statement or something else to Copy from sheet 1 to sheet 2 Closed
Hello, I am looking for a bit of help. I am not sure if this has been asked I tried looking at other post. Any Help to point me in the correct dir...
-
Please helpin creating a macro that will create a new spreadshee Closed
Hello, I would like to kindly ask for help in creating a macro that will generate a new spreadsheet based on the letter entered in a specific colu...
-
A macro in excel Closed
Issue : I have a worksheet with two columns. First column contains some individual names, and second column contains Residence PIN number of the in...
-
Export data from worksheet to another Excel file Closed
Hi I would like a macro that cam help me export data to another file. I have an Excel form which I would like to move the entries into another ...
-
excel question, if cell contains certain word Solved/Closed
Hello, I have a excel spreadsheet that has a bunch of companys with full addresses, phone numbers, etc. They are all in column A. I want the inf...
-
Create folder and save file macro Closed
Hi I am hopping someone can help me with a macro code. I would like to save a worksheet (only the active sheet) into a shared drive (if not acti...
-
Excel help Solved/Closed
In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last date to the far ri...
-
OVERFLOW ERROR Closed
Hello, I USED THIS MACRO BUT AN OVERFLOW ERROR MESSAGE APPEARS. KINDLY, HOW CAN I SOLVE THIS PROBLEM ? Configuration: Windows 7 / Chrome 47.0....
-
excel Closed
I have a spread sheet on Sheet one that has a list of properties that are assigned to various people with some additional info on each line about the ...
-
Format cell values to be included in another cell Closed
Hello, I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows...
-
Conditional Formatting Problum Closed
Hello, i have excel 2010 i have two rows. a & b i want if row a cell value not equal b cell value then change color cell b. (Note this format...
-
managing contact list Closed
Hello, i am looking for a program / code which can be used to keep records of person contacts , address , phone number , dob , id card no , mail id ...
-
Using cell A1 to reflect status of A2-A15 Closed
Hello, I have conditionally formatted A2-A15 to visually represent a stoplight for a series of equipment dependencies (RED, YELLOW, GREEN). I...
-
excel Closed
Sir I ve the following fields in my database Date Receipt No Ref No Name of the student Fees Tc total 01/04/2015 ...
-
Import multiple xmls into a single excel file Closed
Hello, I have > 100 xmls to be imported into excel. Is there a way to import all the XMLs into a single excel? Please help need this urgently. ...
-
Date format change Closed
Hello, The date format is as follows : Dec 15, 2015 10:47:52 AM, I need to change to the format "DD/MM/YYYY". Could you please help me with this. ...
-
automatically email notification Closed
Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47...
-
HOW TO GET FILTERED DATA INTO A SEPARATE SHEET Closed
I HAVE MY DATA SHEET WITH FIELDS GROUPED UNDER NAME, REF.NO, SALES . I WANT TO SORT IT ACCORDING TO THE REFERENCE NUMBER AND PLACE THE PARTICULA FIELD...
-
database report Closed
Dear Sir I have the following fields Month Receipt No Ref No. Name of the student Fees Transport Total. We enter the data according to the recei...
-
corrupted word 2013 document Closed
Yesterday I was working on a very important Microsoft Word (2013) document, when it suddenly crashed. Upon trying to reopen the file Word said: “The f...
-
Cell formatting Closed
I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows how many p...
-
VBA script to copy data to another worksheet if the conditions Closed
Hi , Can someone help to give some VB script copy data from one sheet to new sheet if the conditions matches. I have a guest list with name, email ad...
-
Hello, where am I going wrong with this formula? Solved/Closed
=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...
-
Creating a macro to pull data from a sheet and transpose Closed
Hello, I am working on creating a journal entry form where I can enter a 'A" for accrual and have a macro look up the "A" then create a new spreads...
-
conditional formatting Closed
I want a cell to change colour if the value in another cell is negative
-
Watermark Closed
Hello, I have a draft document that I have chosen a watermark but it seems that the watermark is only showing up on certain pages of my document...
-
If change in Column A - Copy paste data in new worksheet Closed
Hello, Request your help. I have department wise data in a worksheet. Department name is given in Column A. I need to create new excel file for ea...
-
Cant get word back Closed
Hello, I wanted to upload a file on word and so I clicked my document and it said something like do you want to download this on another app. Then...
-
Code macro how to select used rows of a column Closed
Hello everybody, I'm struggle with my macro code. I would like to copy data to a worksheet and paste them to another. My problem is everyday the...
-
I want to build intelligent excel Solved/Closed
Task is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell,...
-
Extracting multiple date from master sheet to new sheets Solved/Closed
Hi I run a sports tipping site and I want to extract data from my master sheet to make other sheets. I.e in sports cloumn I have multiple sports and w...
-
specific price depending on the words in 2 cells? please help Solved/Closed
Hello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches ...
-
Uniques identifiers Solved/Closed
Hello, I have an excel spreadsheet with twelve months (5 columns each) with names and product type for each month. Each month can vary by name but...
-
Excel 2013 has stopped working Solved/Closed
Hello, Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked ...