Office Software Forum
- Excel (9,727)
- Open Office (111)
- Outlook (635)
- PDF (334)
- PowerPoint (174)
- Word (2,181)
-
Create worksheet based on lists & populate data from another... [Solved/Closed]
Hello, I've been recently working on trying to create a fairly large excel workbook & trying to automatically populate sheets inside of it. I h...
-
Highlight cells based on a specific day of the month [Closed]
Hi there. I have a bill spread sheet that is layed out pretty simple. I basically have all of my bills listed in the order they are due each month. Th...
-
conditional formatting [Solved/Closed]
hello I did a table in Excel ( its a vacation tracker) I'll give you an example for what i'm trying to do Ex : my vacation starts from 15-mar ...
-
Attendance sheet [Closed]
Hi, I'm getting Confused and just need someone to help. I know I am looking for something simple but can't figure it out, i got some manhour she...
-
Microsoft Accounting 2009 [Closed]
Hello, I used Microsoft Accounting for a few years now so all my records are with that program. I had XP. I backed up my file because I had to buy a...
-
Search column B for matching value from a row in column A .... [Solved/Closed]
Search column B for matching value from a row in column A and populate D with the value that is in the matching row of B that was in column C, ie XYZ ...
-
Automatic transfer- with just one word [Closed]
I just started a new job and my boss asked me to see if I could have the clients information automatically sent from the master page over to the overd...
-
excel protect a column and a cell [Closed]
Hello, how can i proctect excel column and cell Configuration: Windows 7 / Firefox 23.0
-
Compare Column A to Column B and return Column C [Solved/Closed]
Hello, I have spreadsheet with names in Column A, phone numbers in Column B. Column C has the same names in different order. How can I ha...
-
Monthly Spreadsheet for Equipment Hours- I'm stuck! [Closed]
Daily log for equipment hours I want to make a file with 31 days of worksheets in the workbook for the complete month. The order of the workshee...
-
convert datagrid data to raw data [Closed]
Hello, i've a excel grid with data in rows and coluns with values in each pair (row/column). i need to transform each combination in raw data to p...
-
Possible to import pdf data onlin into excel? [Solved/Closed]
Hello, Does anyone know if it is possible to import pdf data from the internet into excel? Or do I need a special adobe acrobat program to do so? ...
-
how to implement this formula in excel [Closed]
The formula is x= [(A-B)-(C-D)/log((A-B)/(C-D))] It is a iteration where value of A,B,C are taken from excel cells the value of D=1 to 200 ...
-
pdf to ppt converter [Closed]
does anybody have pdf to ppt converter?
-
Copying data from one sheet to another conditionally [Solved/Closed]
Hi gang, I have a spreadsheet with columns A thru H being populated with text. I need to copy columns A thru H from spreadsheet 1 to spreadsheet 2 i...
-
Excel Macro to List one set of values and subtract another [Closed]
I am looking for a macro, that will list one set of values by a code and then move a precious list of codes with values and subtract one from the oth...
-
highlight row on one sheet if a number matches on another sheet [Solved/Closed]
Hello, I have a spreadsheet with multiple tabs. I am trying to figure out how to get a row to highlight on the tab called "Directory" if a number in ...
-
A macro to create new spreadsheet and copy data [Closed]
Hello, In the example below, I want to copy all the date from all the worksheets present in excel. In addition to my requirement to edit value of ...
-
How to define specific format for number? [Solved/Closed]
Hi, I would like to define specific format in excel. For example, if I type 123456789 and hit Enter, it should be 123-456-789 or 123-45-6789 autom...
-
add days to Date [Solved/Closed]
Hello, I need a formula that help me to add days to Date and it gives me the result in date format For example 03/01/2010 + 25 = 28/01/2010 Th...
-
Macro won't paste in second sheet "Run-time error:9" Out ofRange [Closed]
I am trying to copy from sheet 1 and paste in sheet 2. Checking row "G" for the letter "x", the "x" marks the rows I would like to copy from sheet1...
-
If statement using date to change row colour [Solved/Closed]
I have a sheet with the following header row: Reference Client MAWB / BoL Date logged Date completed Days to resolve Logged by Caller type Error ar...
-
Excel 2010-VB Macro formula into many spreadsheets [Solved/Closed]
Hello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable me ...
-
can not send email or messages [Closed]
good morning I keep getting a message "can not send message from my gmail, outlook and yahoo accounts". please help. Configuration: Windows / ...
-
automate the sheet in order to calculate costs [Closed]
I have an order sheet and 3 reference sheets. I would like to automate the sheet in order to calculate costs and for selling different types of produ...
-
IF function using dates [Solved/Closed]
Hi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date filled ...
-
IF function using Dates [Closed]
Hi I am trying to write an IF function for an escalation calculation. What I want is to have a date filled into cell B13 (22 February 2014). The I...
-
Data comparison [Closed]
I have a database compiled in my office of current students in a college program for a particular semester AND a database from administration with the...
-
Macro Syntax Error [Closed]
HELLO THERE NEED HELP TO RESOLVE AND MAKE THE BELOW CODE WORK IN EXCEL(MACRO) ActiveCell.FormulaR1C1 = _ "=IF(RC[-2]=""10X"",""Acquisition on do...
-
Change the column [Closed]
Hello, I have to do the same thing as you but instead of using the column B, I have to use the column A. I tried to change your code but I didn't...
-
Excel cmd button to transfer data from source to another. [Closed]
Hello, Can someone help me with my problem. Is there a way to create button to transfer data from source sheets to any other sheets in the same wo...
-
how do i change the result of a formula to normal text or values [Solved/Closed]
Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that for...
-
IF Formulas with Dates [Closed]
Hi all, I have a large spreadsheet that contains revenue information tied to sales deals. Column A contains the expected deal closing date and c...
-
data sorting [Closed]
Hi Folks, I need your help in data sorting. Basically I just want to automate the data to be sorted to another table, Names from table1 to table...
-
Excel MMYY format in order [Solved/Closed]
Hello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec 2012...
-
Macro adding a row and numbering it in Excel [Closed]
Hi, Please could someone help I am trying to record a macro that will add a row below and number A2 with a number say 1, 2, 3 etc. I also need to...
-
Date format [Closed]
Hi, can i have solution for this question how to change date format this case to 21/11/13 to this 21-Nov-13. Thank you............
-
Macro [Closed]
Hi, I want to setup a Macro to cary these 2 rows and coloms when I hit the Macro button in excel. Can any one help me. I am staeting with E7:F7. T...
-
Office 365 activation key ? [Closed]
How & where to get office 365 activation key? I am unable to use it now its been six months i started using Office 365 but suddenly it sopped working....
-
Excel formula help [Solved/Closed]
Hello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my mind. ...
-
Apply conditional formatting rule if value is true? [Closed]
Hello all! I have been searching for this answer for many days now, and I am getting quite frustrated. I'm not sure if it will work or not, but here i...
-
inserting photos or image into a PDF [Closed]
I have PDF complete office edition 4 and I am trying to update a flyer that we created a few years ago but the program wont let me change or insert a ...
-
Track Office Log IN and Log out timings [Closed]
Hi Team, Thanks for providing me an opportunity to be a part of the wonderful Team. I would need a Macro to track the shift timings of the emplo...
-
how do i change the result of a formula into normal text ? [Closed]
Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that f...
-
if cost is 18.66 what would be 0.6% of it (calculation method) [Solved/Closed]
and if basic pay 65000rs what would be the 2.5% of it(calculation method)
-
Copy Data from one sheet and putting it below a particular Cell [Closed]
I have a excel with 3 sheets . My requirement is to pull data from sheet1 ,sheet2 and put it into sheet3. There would be two headings in sheet 3 1...
-
Moving Information from 1 set to another based on an IF [Closed]
I have two worksheets. 1 is Proposals 2 is Projects When a row in Proposals is given a Project #(a cell in that row) I need the cells in that row to ...
-
How to move data from one sheet to another [Closed]
I have an excel spreadsheet, and I need a macro , in sheet1 I have several values of 7 numbers in a cell, example 1|2|3|4|5|6|7| up to 93|94|95|96|97|...
-
how to formula the table [Closed]
Table 0 to 1000 value is 2 1001 to 2000 value is 3 2001 to 3000 value is 4 3001 to 4000 value is 5 4001 to 5000 value i...
-
Conditional Formatting with dates [Closed]
Hello, Your help would be greatly appreciated I have a cell with a date in it (A1). I want that cell to change colour if the following criteria is ...
