Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Help with a school Directory Closed
Hi all, I am creating a school directory. My columns are Last Name, First Name, Father/Mother, Phone, Email, Address, Zip, Teacher, Grade. I ha...
-
Urgent,,,custom database from one entry sheet to multiple sheets Closed
Hello, Thank's in advance...for helping in my problem I enter data in a sheet and based on that i print few page report that contains that variable...
-
Copying to cell information Closed
Hello, I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The informat...
-
Enable Macro Security Via Macro Or automatically Closed
Hello, Dear Friends i m not good in english so sorry in advance for bad english. but i need to enable macro automatically when worksh...
-
wireless router password Closed
Hello, I need a password for my router192.168.1-1 at 22356 mcintosh avenue, maple ridge bc. canada papa
-
Cant send emails in Outlook Closed
Hello, i have a problem sending my emails from Microsoft Outlook 2010. I have to log into my gmail account in order to send emails but I can rece...
-
Transfer data from multiple sheets to sheet 1 based on criteria Closed
Hello, I am creating an estimating workbook where I have multiple product sheets that list qty, part#, description, volume, lbs, list price & disc...
-
Creating custom database from one entry sheet to multiple sheets Closed
Hello. I enter data in a sheet and based on that i print few page report that contains that variable data I want to some extra work so that every...
-
Change content of a cell based on a value in a different cell Closed
Hello, I would like to be able to total values based on an index number and put the total in a different cell. Here is an example: If cell C2 ...
-
Pop up setting Closed
Hello, I have got two excel sheets one master sheet that gets updated everymonth with the new employees joining that month. In the second sheet ...
-
How to open hidden & locked file? Closed
Hello, Good Morning, I was about to click the print option for my Microsoft Word File but I clicked the exactly below option which was "Hide and ...
-
convert date to English words Closed
Hello, Hello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twent...
-
cant open pdf when word is open Closed
Hello, Am using adobe acrobat reader, and i can open all my pdf files through that but the problem is when i open a word file and i minimize that ...
-
Concatonating within commands??? Solved/Closed
Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...
-
Automatically populating master excel sheet from other files Closed
Hi, I am fairly new to Excel, especially when it comes to macros. I will be having a lot of files saved in a particular folder that contain inspec...
-
why the type mismatch error? Closed
My question is in the comment in the code: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Cells.Count > 1...
-
format row based on text length Closed
Hello guys, Can you pls help me? I am beginner in VBA and I need to sort out one macro. I have table and need to have highlited row with color, bu...
-
using if condition with date function Closed
Hello, Sir, i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date col...
-
Step by Step Instructions Closed
Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a prompt in...
-
get month name and year from date Closed
Hello, how do I can convert the date in to month name and year ex. 01/05/2015 , I want to get month name as May and year 2015 pls help me, b...
-
Copy & paste Data and increment to next cell having data Closed
Hello, Configuration: Windows 7 / Internet Explorer 7.0 I am new to Excel Macros. I situation is I have a sheet with 40000 rows range (A1: ...
-
Change date automatically on the sheets Closed
Hello, I have a document in Excel, and has 5 different pages; all of them have the date on top. I need to know, how I can set up the formula or th...
-
VBA Copy Issue Closed
Hello, I have written the following code which creates a variable # of additional sheets in my workbook based on how many rows have names in them...
-
Data Validation dependant lists, Excel 2010 Closed
Hello, I am in need of a way to create a order form from a table (product list) using Data Validation. The table is 8 columns and aprox. 5000+ r...
-
impact font Solved/Closed
hello, is the impact font included in windows 8.1. Configuration: Windows XP / Firefox 40.0
-
Help MSB (microsoft visual basic) code for an Excel Macro button Closed
Hello, I am trying to create a macro to help the input in a complex excel file. I have created several dropdown menues to choose from a list: ...
-
Comparing columns and returning value Solved/Closed
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...
-
You can't Delete a Smart Art Shape Closed
Hello, Hi. I have looked everywhere for a solution to this problem and have yet to find one. For all accounts and purposes you cannot delete a sma...
-
search,compare,update,indicate data in excel sheet (macros VBA) Closed
search, compare, update and indicate data in excel sheet with macros VBA Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. ...
-
convert blank row data in colums Closed
Hello, how we convert blank row data in column Data Name 50 V10 V12 V3 V6 51 V1 V2 V4 V5 V7 52 V8 53 V9 55 V11 57 V13 58 ...
-
Auto update data from one sheet to other sheet Closed
Hello, I would be very grateful if some one help me this issue! I have two sheets with similar format. In the first sheet, I will input many r...
-
data transposition Closed
Hello? I need to transpose my data and need some help. First picture is an example of my raw data and the second one is the data after transpositio...
-
beginner in VBA. I have following problem statement Closed
Hello, I am a beginner in VBA. I have following problem statement: I have a workbook i.e WB1 which is having a unique id in A column, product ...
-
Financial tracking made easy - I hope! Closed
Hello, I am trying to develop a finanical transactions tracking worksheet. I want to reduce the amount of data entry so Im downloading my fina...
-
Word "False" kept on Appearing? =IF function Solved/Closed
=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...
-
conditional formatting Closed
Hello, I'm trying to write a conditional format formula populating one cell (column of cells) based on the text content of cells in 2 other column...
-
date range to division Closed
Hello, we capture birth date as date and we would like to convert to division Month/Year 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006...
-
sumproduct based on relative cell Solved/Closed
Hello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...
-
Macro to copy data from one sheet to another with >1 variable Closed
Hello, I have been using macros to copy data from one sheet to another without issue, until my data has become a little more complex. I have sheet 1...
-
Updating values automatically Closed
Hello, I have an issue. I have 2 workbooks. I need to copy data from one work book to other workbook dynamically. That is if a value is changed in w...
-
Conditionally format cells based on text contained in other cell Closed
Hi - I am running Microsoft Excel for Mac 2011 and want to conditionally format an array of cells based on the text contained in another cell. For exa...
-
using word to pdf converter in application Closed
i am looking to add a functionality in my online app, such as a button which can convert a word or doc to pdf. I see many freeware such as foxit reade...
-
Macro to autogenerate sheets based on unique values of a list Closed
Hello! I would greatly appreciate if anyone could help me with a macro. I have a number of populated rows in one sheet (Sheet A) and one of the co...
-
copies and saved in a different column Closed
Hello, can you guys help me with this. I want to input a data in cell A1, then it automatically copied into cell B1. then if I input again anoth...
-
copy row from sheet 1 to sheet 2 with formula Closed
Hello, i need to copy a row from one sheet to another with formula and keep updating the data in sheet 2 every time i change the data in sheet 1 ...
-
vba for copy from sheet 1(form) then paste to sheet 2(database) Closed
Hello, newbie here. Please help me by giving a vba that could automatically make a database. I have a form(sheet1) detailed with various inf...
-
stack range of data to next empty row in other sheet Solved/Closed
Hello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...
-
Macro that kills a macro when a new workbook is opened. Solved/Closed
Hi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...
-
Comparing 2 worksheets & extracting matched and unmatched data. Closed
Hey guys, I'm trying to compare one column in a worksheet with another column in another worksheet and also at the same time, extract matched value...
-
convert text paragraph to excel columns Closed
Hello, i have few pdf files that needed to be entered to excel columns. i have worked on a html software at my last work that could convert it to ...
