Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
No cell borders or text colour in Excel Closed
Since upgrading (?) to Windows 10, cell borders do not print. I also cannot change the text colour. Spreadsheets built before the update also have ...
-
Excel - A macro to rename existing worksheets based on a list Solved/Closed
I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just renumber ...
-
Can't open a word 2007 doc created in the same ms word 2007 Closed
Hello, I have created a file in ms word 2007 and when I immediately tried to open the file , it does not not open--But a message displayed like--t...
-
Inserting a picture with Path name in a Variable Closed
Hello Guys, I am getting an "Error 1004: unable to get insert property of Picture class" with the following code. Looking forward for your guidan...
-
can only use Microsoft Office 365 Online Closed
Hi Everyone, How come I can only use Office Online and sometimes. I have found it hard to open it up offline which is a nuisance sometimes. As I am...
-
Inserting image in a particular cell in VBA Solved/Closed
Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this...
-
Outlook not sending email Closed
Hello, I have this problem, my outlook 2007 works fine when connected to DSL/Wifi of one ISP. But when connected to other ISP mobile/3G EVO it rec...
-
macro doubts Closed
Hello, How to create new excel worksheet in a same workbook and names of sheets should be same like form1,form2,form3....... Configuration: W...
-
merge cell Closed
Hello, What if the compared cell is a merged cell. Example, comparing the values in column C with the merged cell values in Column A, expectin...
-
Exel formulas Closed
Hello, To find position class of the student in Mark card
-
A Macro to Create New Workbook and Paste Values Only Closed
Hello, I have a workbook with three tabs. I would like to create a macro for a command button that will create a duplicate workbook named "Current...
-
Autoploting (Master to other sheets) Closed
Hello, I have a master file for all the transactions in one financial year. This file currently has 4 sheets: EGC,SSM,RSL,MF. The first three are...
-
Macro - new sheet per name list and add template in each sheet Closed
Hi all, I'm a new comer here, but looking forwards to learning and helping others!. I am trying to create a macro that will: 1. create a new s...
-
IF statements with dates and criteria Solved/Closed
Hello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set of En...
-
cannot open email pdf attachments Closed
Hello, why can I no longer open pdf files, even looking back on old emails which I have viewed before, now it says files cannot be downloaded. have I ...
-
Picture issues Closed
Hello, I am trying to add a picture to an inventory list. It is made to just write the item code and the details would be generated into other field...
-
merge column Closed
Hello, Hello, Example, comparing the values in column C with the merged cell values in Column A, expecting the result of the values from col...
-
Date, time (if the box says YES) next to someone's name Closed
Hello, Is there a way for me to have the Date, time (if the box says YES) next to someone's name? http://imgur.com/a/SYpcV For example if s...
-
Help with Excel Formula Closed
Hello, I am a beginner at Excel. Trying to figure out formula for: IF DATE in column A is greater than DATE in column B, highlight. Configur...
-
if a cell has specific data, copy entire row to new worksheet Closed
Hello everyone :) This is my first post and I'm really needing some assistance if at all possible! I am a school teacher, trying to create a spreads...
-
Date format Closed
How do you set the Excel date format to display "Wed 09 Nov" and not "Wednesday, 9 November 2016" I have tried several combinations to no avail. OS ...
-
copy information from the one excel spreadsheet to the other Closed
I have two excel spread sheets. Basically I need to copy information from the one excel spreadsheet to the other. Here is the tricky part. the sheet I...
-
Difficult Lookup formula Closed
Hello, I have a difficult question that may not have an answer. At least, I haven't found a formula that works. A ...
-
Clash of Clash Closed
Hesabimin sifresini istiyom
-
change the font of the Equation Symbols Closed
Is it possible to permanently change the font of the Equation Symbols? Mine are set at Cambria Math and I'd prefer Arial. Thank you
-
duplicate values in multiple columns Solved/Closed
Hello, I'm looking for a formula for a case mentioned below: Consider we have values in three columns I need to find a formula which compar...
-
Not able to send mails Closed
Hello, I'm receiving mails but I'm not able to send my attached copy or mails Configuration: iPhone / Chrome 54.0.2840.68
-
Copy data of one sheet to other sheets Solved/Closed
Hello, I want a VBA code or excel formula that automatic copy of data from one sheet to another sheets(either sheet 2 or sheet 3...etc)..suppose In ...
-
excel 2003 auto data copy criteria wise sheet to sheet vba code Closed
Dear Concern, I have one excel data file like below But I want to make a automatic data copying system on data sheet to another sheet using mac...
-
How to activate the Button as Activecell Closed
Hello Guys, I would like to know if there is any way to make the cell in which the button is inserted as the ActiveCell when i click the button? ...
-
Report sheet Closed
Pls assist me on how to gives a class position of students after tabulation of the finals scores based on highest to Lowest
-
Respective names required Closed
Hello CCM, Please give me solutions to solve my problem.. 1) I have created 2 worksheets, one sheet having two columns like below Code ...
-
Want to implement a Macro to Find and Copy to another sheet Closed
Hello, I have tried to implement a Macro on Excel for my data, I have a search box made for my data on cell D1 I want to make a macro in which...
-
Compare 2 MS Excel sheets and copy data to a new one Closed
Hi all, I would like to know what to do for the situation below - I have 2 sheets named as "Current" & "New" and they both have the same columns a...
-
Copying & pasting data in next available row in same worksheet. Solved/Closed
Hello, I would really like assistance to write a vba code for a macro (using a drop down list) that copies data from A4:E4 and pastes it down in t...
-
Value from matrix table Solved/Closed
Trying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2
-
Trasfering data with vba Closed
Hello, I have sheet1 of data with 2 columns with 26 row And i want to copy this data to sheet2 but when i copy this data it overwrite the old one ...
-
Inserting Picture with Variable Closed
Hello Guys, I am trying to insert an image into a particular cell by calling the value stored in the variable via an InputBox. The following code...
-
how to auto insert photo in excel with matching cell and pic fil Closed
Hello, I have a list of photos names that I would like to auto insert the photos into the cell according to the name. For example: in cell B1 is pi...
-
Macro question: copying different value x number of times Closed
Hello, I am trying to paste a different value [which I copy from cells(1,i)] every 9 rows down column A. For example, will copy value B1 and paste...
-
looking up same value and returning location Closed
can i look up the same value in 2 separate spreadsheet and return the location? Spreadsheet 1 A- item number B item description Spreadsheet 2 ...
-
Copy and paste a value x times dependent on value of cell Closed
Hi, I am looking to make a macro which will copy and paste a value into a column x times depending on the value of x... After it has copied this, I...
-
VBA: Lookup A Value and Deduct A Value Closed
Hello! I hope you guys are well! I oh so desperately need your help. Here's what's going on...I'm gonna try to explain this as clearly as I can....
-
Auto create sheets and dates for days and months. Closed
Hello, Greetings. I am seeking for a help. I'm a noob to Microsoft Office apps. I need to do something using excel. The issue is how can I auto...
-
how to manage drop list Closed
Hello, if i have two dependent drop list one in E15 include 3 item ( only fresh ; only exhaust and both ) other in f 15 when selec...
-
two tables values with diffrent order and number of values Solved/Closed
Hello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME | SKU asd.........21398763 ...
-
Compare 2 excel sheet Closed
Hello, I have these situation. I have 2 sheet of excel. one is master copy or original 1. second are excel sheet export from application. I need to ...
-
excel urgent Closed
Hello, hello im tamil,, i have more then 1000 line no in row,,, the line is nothing but file no,, and i have 1st submission , second submission, a...
-
set range for macro running Closed
if i have macro locked cells with change value of other cell , but this macro work from A1 i ask if i can modified code to let macro begi...
-
Conditional Formatting Closed
On my spreadsheet I have the following formulas on a date; Ex.J6+30=K6(Due Date), then Today()-K6=L6 (Days to implemetation). Now, when I have no dat...
