Office Software Forum
- Excel (9,795)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
vba copy data from a range and paste to empty column Closed
Hello, I have a set of values in range P6:P15. At the end of each month, I would like to copy and paste the data from the current month column to ...
-
Automatically transfer excel row to a different sheet based Closed
Hello, I have a spreadsheet for paid & unpaid invoices from our customers and would like to have the row automatically move once I mark it pa...
-
VBA Using subroutines - help please Solved/Closed
Ok guys, I have a problem (well more than one, but Im not sure I should mention those on this forum!). Im in the process of writing an Excel macro ...
-
windows 7 adobe player & Excel Closed
Hi How to download the adobe player new version for Windows 7 & Excel By mistake both have been deleted
-
sort Type and Size Excel formula Closed
Hello, can someone please help? I'm trying to write a formula that would sort Type and Size on the following spreadsheet which has the following: ...
-
Extracting matched observation and its corresponding row Closed
Hello, I have excel sheet containing around 100K observations (rows). There is one column say "A" containing some IDs and each ID is having 10 par...
-
Can't change format of cell Closed
Hello, Using Excel 2013. I have a document which consists of various combinations for padlocks in a format of 00-00-00 most come out correct...
-
T-Shirts Closed
Hello, I have 3 columns Male, Female AND Long Sleeve, I then have 7 columns of sizes 4XL, 3XL, 2XL, XL, L, M, S. If and x is placed in one of the 3...
-
conditional formatting Closed
I am creating a dashboard to monitor the metrics of several facilities. This spreadsheet has a summary page and each facility has their own sheet to ...
-
Effects of upgrading MS Live mail Closed
MS Live Mail 2011 came with my computer, and I noticed I could upgrade to 2012. Will this override anything on my computer where I lose all my emai...
-
Explain formula Closed
Hi, please can anyone explain what excactly does this formula? =INDEX(Sheet1!$A$2:$A$13,SMALL(IF(FREQUENCY(MMULT(--(Sheet1!$B$2:$B$13={"jan","feb","m...
-
Date format nightmare Solved/Closed
solved with this: Because it is not a date to excel. 1. Select the column in which there was date 2. Goto data and choose text to column 3....
-
total number of text Closed
In column C, there are drop down values for Complete, Incomplete, and In Progress. I would like to put summary statements that say: The TOTAL number...
-
Matching Names Closed
Hello, I have two lists with names approximately 10,000 on excel. I want to find out if there is a formulae for near matches against the two list...
-
Office Outlook trouble sending mail Closed
I have tried most of the setting changes i found in previous answers and still can not send emails please help.
-
Pleas:Using a Macro to Insert one Picture into Cells in range Closed
Dears, I would like to ask you for help with following topic: I would like to insert a picture from file stored in my computer defined by name of f...
-
Using a Macro to Insert one Picture into Cells in range Closed
I would like to insert a picture from file stored in my computer defined by name of file from cell B2 to cells in range given by lines in C2 and colum...
-
Count multiple instances of keywords in a cell Closed
Hello, I have to scan through a column of text comments for certain keywords, and count the number of times these keywords pop up in each comment. ...
-
Automatic Key In Closed
Hello, I have 2 main sheets at play here: SS Order Order Placement SS Order is a supply allocation form that has loads of past records and ha...
-
Macro Help Closed
Greetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one shee...
-
Excel sum value... Solved/Closed
Dear I would like to know how to do the below mentioned formula I have tried but not resulted. Excel - Sum value in column when cells contains ...
-
Formatting Numbers in mail merge from Excel to Word Closed
Hello, I have asked the question before but I forgot to print the answer for future reference. I want the mail merge to format to 2 decimal places ...
-
Macro Help Closed
I have created a macro in which I need to copy 100+ variables from one sheet to another. Due to various constraints, I have found it easiest to paste...
-
Not being able to find the range path..need help!!!!! Closed
Sub INSERT_PIC() Application.ScreenUpdating = False On Error Resume Next ' Macro3 Macro ' Macro recorded 22/05/2002 by SVK ' Worksheets("Pictu...
-
Insert and delete column with macro Closed
I have master data that need to be edit first, it contain many unused columns but not merger and i want to delete those columns after that i need to i...
-
Formula Help Solved/Closed
Can someone please help me with this formula =IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470))) What i am trying to do is : if G2 has the...
-
Excel 2010: Adding rows based on value from other cell Closed
Hi, I see that similar questions have been answered many times but mine is a bit different. First of all, i would like to say that i am very new...
-
summing results from vlookup function Closed
I have a table with 5 columns. I am trying to use vlookup and a variation of sum (sumif) to compare the value in cell A5 to the values in cells A20-A6...
-
Conditional Formatting based on year Solved/Closed
Guys, I come again cap in hand with another plea for help on a sort of finished project, but I want to make it better. I have some conditional f...
-
How to Type in one worksheet and have it appear in another Closed
Hello, if anybody could please help me with this, I have 2 spread sheets. They are exactly the same except one is in English and one is in Spanish. I ...
-
How to type in one sheet and have it show up in another Closed
I have 2 spread sheets. They are exactly the same except one is in English and one is in Spanish. I would like to send the spread sheets to customers ...
-
SumIf Closed
I have a column E with dollar values. I have a column L with "y" or "n"; I'm trying to figure out a formula that could sum only the values in column ...
-
Extracting rows from excel Solved/Closed
Hi there, I have an excel sheet with a very large data. I want to extract different rows and write them in to different sheets of the same excel (or ...
-
Increment cell value based on change in value of another cell Closed
Hello, Say I have a value of 100 in cell B3 and I need this value to increase/decrease based on the change in value of A2. How do I do that? For e...
-
Excel Query Closed
Hi I looking for a formula that will calculate an average order spend by day without having to do this manually(1, 2, 3 ). So for example it tak...
-
Macro to Copy Closed
I am new to writing macros but need help in creating one to copy data from one cell to another with conditions. I have two spreadsheets merged from t...
-
blackberry Closed
Hello, i cant open my blackberry mobile because i forget id or password Configuration: Windows 7 / Chrome 47.0.2526.111
-
Copy and Paste Multiple Closed
Hi I'm looking for away to be able to copy a single cell from multiple sheets (tabs) for example cell a1 and list it's contents on a separate summ...
-
Auto Populate record from one sheet to another Closed
Hello, I'm working on a commissions spreadsheet for my company and would appreciate some assistance with a question I have. There is a separate ta...
-
Data Link Closed
Hello, I'm needing help please, I'm trying to figure out how to either: Link an Access database to an Excel Spreadsheet where it has a templ...
-
Copy data ranges from multiple excel worksheets Closed
Hello, I have a series of worksheets all with identical formats but different data information. I want to take information in cell ranges e30..k...
-
Free Word processing software Closed
Is there free office word proccessing software and how can I get it?
-
Search for text and copy Closed
Hello, I have two columns, A contains the list of a company and C contains emails. I would like to search the email column for emails containing ...
-
conditionally format a cell so it turns a certain colour Closed
I was wondering how to conditionally format a cell so it turns a certain colour when it goes past a certain date. Thanks
-
Conditional formatting colour fill Closed
Hi all, I want to set up a cell in Excel with solid fill depending on % completion of other tasks. The data bar conditional format will do it, but ...
-
If, and question Closed
Hello, I'm trying to work a formula that will change a given value in one based on dates going into several different cells. Example. If I pour a co...
-
Column to vlookup Solved/Closed
I am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...
-
IF function with Time duration Closed
Hello, I dont understanding why this can't work : =IF((g2=timevalue("0:30"));"25) G2 has a time duration time unit in it which equals 0:30. ...
-
Disable a cell in excel using VB code Solved/Closed
Hello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...
-
Create a button with some conditions Closed
Hello, please if anyone can help on this it will be gratefull. I need a button to create a new sheet, but when you press it, which ask you assign nam...