**0**

votes

**0**answers

5 views

### Can I split a spreadsheet into multiple files based on a Row in Excel 2013?

I have a spreadsheet in excel 2013 which have multiple column and rows. I need to send some columns to different people separate files. Please anyone can help me in this. Please try to use macros, or ...

**0**

votes

**0**answers

5 views

### create an excel sheet to schedule employee annual planner

![enter image description here][1]
I want to create an excel sheet to schedule employee annual planner.
If anyone submits leave application, while entering i need to find anyone applied for these ...

**-5**

votes

**0**answers

20 views

### Excel: Can anybody help me to take-off quantities of loose furniture in the best and fastest way?

Can anybody help me to take-off quantities of loose furniture in the best and fastest way?
Information as follow:
There are about 2000 different types of rooms and 300 sets of different furniture
...

**0**

votes

**0**answers

7 views

### Changing cell style groups

I was sent here from stakoverflow
When I create a new cell style in Excel, it goes in a group called Custom. The standard groups include Good, Bad and Normal, Data and Model, Title and Headings, and ...

**0**

votes

**1**answer

17 views

### Round up or down to nearest multiple of .05 in Excel

Example, I have 221.52, 195.97, and 138.88. Now I want it to automatically round up or round down to the nearest multiple of .05, producing 221.50, 195.95, and 138.90. Is there a formula for this?

**0**

votes

**0**answers

12 views

### Extracting HTML from Excel to enter in MySQL/Wordpress site

I have a WordPress site and an Excel document. I'm not familiar with Excel formulas so forgive me.
The document contains a lot of names, email addresses and telephone numbers. I want to create a ...

**0**

votes

**0**answers

12 views

### Excel Graph with 2 X-Axis Non-Linear Mapping

I have the following problem someone might be able to help with.
I have two risk scales, one from 1 to 11 (old) and one from 1 to 21 (new), where the mapping is non-linear, i.e. old scale->new scale ...

**0**

votes

**1**answer

11 views

### Excel Data Extraction Formula

I am trying to run a report to evaluate the downtime of devices in a network. The OpManagement report doesn't have any customization available for output reporting. So I am looking for a way to ...

**1**

vote

**1**answer

8 views

### Summing multiple cells that match row AND column criteria?

I've been given a file with 2 years worth of dates as column headers and sales info below. There's also a column that contains Year data. I'm trying to sort by both Year and Day of the Week. I'm ...

**0**

votes

**0**answers

26 views

### Pairing Numbers in Excel

I have a list of congressman (and some of them repeat) and I’m looking for something that will fill in the matching distract number in the corresponding cell, so I can eliminate the risk of the human ...

**0**

votes

**0**answers

8 views

### Access 2013 How to prevent from saving a record

I had created a form in access 2013 to add records to a table but I'd noticed that if I close the form without saving the record access still saves it to the table anyway. I would like to know how to ...

**1**

vote

**0**answers

7 views

### Excel pivot table: Show values instead of summaries

I have a table of data like this:
ID |Name |Brand |Model |License
------------------------------------
1 |Foo |KOM |830 AC |A
1 |Foo |KOM |930 E |B
1 |Foo |CAT |980 H ...

**0**

votes

**1**answer

17 views

### Excel Index/Match Sum

I have 2 worksheets in Excel. Both have data from a 2 different databases. The first tab has part numbers and costs (could be different day to day), the second has how many times that part number ...

**-1**

votes

**0**answers

10 views

### Macro - Creates individual workbook based on template on sheet2 and data on sheet2

Option Explicit
Sub CreateBooks()
Dim rCl As Range, rRng As Range
Set rRng = Sheet1.Range("A1").CurrentRegion.Offset(1)
Application.ScreenUpdating = False
For Each rCl In ...

**0**

votes

**1**answer

27 views

### Excel: what makes .xlsx files use less space than .xls files?

I have some xls files without around 12 tabs containing data, links to other excel files, some data validation, and some conditional formatting. Saved as xls, they use around 1.2-1.5 mb each, but if ...

**-1**

votes

**2**answers

50 views

### If one number then a different number

I have two columns of numbers on a data page, over 500 pairs. And I need a formula for the working page that will insert the second number in “column B” if the first number is in “column A”. So if my ...

**0**

votes

**1**answer

23 views

### Schedule; want to check if everyone is present [on hold]

We're making a schedule in Google Docs / Excel
We want to be sure we've got everyone in the schedule....
So we make an Excel per day we're everyone should be present in a day (row 6/7). I know I ...

**0**

votes

**1**answer

17 views

### Run a Mail Merge using a Database from Excel [on hold]

I have an Excel database that lists all our employees and the training courses they have completed. Each course is listed on a separate line with the employee name.
I would like to run a mail merge ...

**0**

votes

**1**answer

18 views

### How to filter common values of two columns with advanced filter?

I have one column containing some common values that are in another column. I want to filter values from one column that are present in other column but without using VLOOKUP. How can i do it using ...

**0**

votes

**0**answers

22 views

### How do I sum the last 4 cells in a column that have a value greater than 0 & contain only numbers in excel?

I have created a spreadsheet for working out the pay of our employees. The data starts in Row 14. Col A contains that week's pay date eg. 24/3/15 etc. Col B has the total hours the employee has worked ...

**1**

vote

**1**answer

18 views

### Different colored columns in excel

I have data such as this:
1 | 2 | Y
2 | 4 | N
3 | 3 | N
4 | 2 | Y
...
I need a bar graph that will display column 1 as the x-axis labels with column 2 as the y values. The color of each bar will be ...

**0**

votes

**2**answers

29 views

### Excel formula for average daily profit

I have a table that has just two columns, Date and Profit:
Date Profit
24 - March 25.00
24 - March 19.85
25 - March 5.25
26 - March 6.36
26 - March 10.18
26 - ...

**0**

votes

**3**answers

25 views

### Excel macro: Last non-empty cell in a column

This is a followup question to this one.
The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel:
=LOOKUP(2,1/(A:A<>""),A:A)
My ...

**-2**

votes

**1**answer

15 views

### How to transfer spreadsheet to downsized spreadsheet [on hold]

Can I copy an excel spreadsheet with 20 columns and paste into a template using only 8 of those columns with the column sizes slightly changed?

**0**

votes

**1**answer

15 views

### How do I prompt a user with file “Save As” dialog using a macro?

I created an Excel macro to replace data from "Quote" to "Invoice", but after running the macro, I wish for the macro to continue to run and stop at: "Save As..." mode so that the user can provide a ...

**0**

votes

**1**answer

28 views

### how to CONCATENATE array text?

Let the cell A1 has "abccba"
Now I write a formula in the cell B1 =RIGHT(LEFT(A1,ROW(INDIRECT("1:"&LEN(A1))))) it gives value "a" or array string as{"a";"b";"c";"c";"b";"a"}
Now when I concatenate ...

**0**

votes

**1**answer

21 views

### Excel 2013, Vlookup - accessing different sheets.within a workbook

I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc)
I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING ...

**0**

votes

**0**answers

16 views

### Hyperlink to file in TextMate

I use TextMate to edit LaTeX documents. Let's say I have the file foo.xlsx on my Desktop. In my .tex file how can I add a hyperlink to foo.xlsx, so that when I click on the link, the file is opened ...

**1**

vote

**0**answers

23 views

### Office 2013 on Windows 8.1 gives out of memory error when opening files

We have the same error that has been posted here:
Problems opening Excel attachments from Outlook
Namely, when a user opens a file from the internet, the internal network or an outlook attachment ...

**0**

votes

**1**answer

42 views

### excel 2010 Vba, looping through named ranges, Run-time error '1004':

I am assigning the same Macro to several OptionButtons.
I try to determine in which named Range the cklicked OButton is located.
So I get the Cell of the Button and loop through all named Ranges in my ...

**0**

votes

**1**answer

25 views

### Excel Daily Average Profit

I have a table that looks like this..Just two column..Date and Profit:
Date--------------Profit
24 - March------25.00
24 - March------19.85
25 - March------5.25
26 - March------6.36
26 - ...

**1**

vote

**2**answers

38 views

### Microsoft Excel - comparing values of multiple columns against values of multiple other columns

I have a spreadsheet containing names.
I have 5 columns of unique names, let's call the headers:
Name A
Name B
Name C
Name D
Name E
I also have 10 columns of other names (not necessarily unique), ...

**0**

votes

**2**answers

26 views

### Finding a value in one colunm that matches another column then putting that value in a third column (excel 2010)

All of the values are texts since the are usernames that are from two different systems.
so one column has:
Column A Column B
smit19108 Fred99015
Fred99015 Smit1908
...

**1**

vote

**1**answer

24 views

### How can I assign Excel keyboard shortcuts for macros that use keys other than Ctrl + {alpha character}

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how:
...

**1**

vote

**1**answer

42 views

### Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...

**0**

votes

**0**answers

29 views

### setting upper and lower limit excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale ...

**0**

votes

**0**answers

25 views

### Multiple Values in one cell needing separate row in Pivot Table

I am looking for a solution on how to have a separate row in a pivot table for 2, 3 even 4 values in one cell.
Example - Columns are as follows: Date, Job Name, $ Value, Distributor Quoted, ...

**2**

votes

**1**answer

30 views

### How to unselect Excel Cell using Keyboard Shortcut?

One can select multiple Excel cells (either contiguously or not) using the keyboard shortcut Ctrl+Click.
How do you deselect one or more of these previously-selected cells?

**1**

vote

**2**answers

46 views

### Excel: Sum a column of text excluding duplicates in another column of numbers

I am trying to figure out a formula. I need to know how many times a certain issue happens based on case numbers. Meaning there are multiple entries under a specific case number for that subject, but ...

**0**

votes

**0**answers

16 views

### Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[].
Is it possible to import these byte[] into Excel and convert them back into images?
I already have a connection to the database in my Excel ...

**1**

vote

**0**answers

25 views

### Cell Formatting, 0.00 where blank value

I have some cells that are formatted as hours and minutes i.e. [h]:mm.
If no value exists in a cell I want the cell to show 0:00 without having to manually type.
It needs to be user friendly, so if ...

**0**

votes

**1**answer

14 views

### Return transposed list of all strings in a row in Excel

In my Excel (for Mac 2011) sheet, the range B2:2 contains mostly empty cells, but some cells contain strings. I would like to print these strings into a transposed list beginning at A12. This list ...

**2**

votes

**1**answer

26 views

### Excel Formula - returning data

I have a spreadsheet that has four columns of data.
I want column number four (D) to display the value of column three (C) IF the number next to it in column two (B) matches ANY number in column one ...

**1**

vote

**1**answer

28 views

### Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...

**0**

votes

**1**answer

27 views

### Excel converts datetime to other format where days are low enough to be months

I live in europe and our datetime format is usually dd/MM/yyy
I have an excel spreadsheet where I have ALOT of dates
But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...

**0**

votes

**1**answer

17 views

### run macros assigned to many excel sheets of a workbook, with one click

I have one workbook with 8 worksheets.
I have a macro assigned to each worksheet.
I want to run all 8 macros from one worksheet in one click(by clicking one button, to run all 8 macros).
How can ...

**0**

votes

**1**answer

24 views

### How to link drop down cells in 2 different worksheets?

I am trying to make a spreadsheet for my work and I want to create a drop down list which have to contain "Canceled","ordered","accepted".(I know how to create this drop down list). Now I want the ...

**0**

votes

**1**answer

19 views

### Excel VBA: How to use a unique username or save location for an export pdf macro

I have a macro that prints a uses the internal Excel method ExportAsFixedFormat to print a worksheet as a pdf and save the document to the desktop using a unique file name structure.
...

**0**

votes

**0**answers

27 views

### How do I stop excel duplicating values in VBA?

I run a code that groups same products together and total quantities of those products. However It only works if all items are filled in if not it duplicates. For example:
Instead of
Product 1 ...

**1**

vote

**1**answer

19 views

### How do you do an Excel format string that represents number of days in the times-apn

Let's say A1 contains a value which is the number of days in duration. Example:
17.121875
That number represents the number of days.
I would like to use an excel format which ultimately makes it ...