**0**

votes

**0**answers

17 views

### Get information from one worksheet and move it to another worksheet [on hold]

Basically, I could do this manually, but I have a lot of information and it would take me a lot of time. I am trying to find the right formula.
I have 8 worksheets in Excel.
Details
Date ...

**2**

votes

**2**answers

113 views

### Combine Data in Multiple Rows into Single Row

I have a table with information about people (Name, HP No., Home No., Email etc). However, they are in different rows, and not all rows have all information.
How do I combine all information about ...

**0**

votes

**1**answer

25 views

### Date formatting from a derived/computed column

I have a column(A) in excel with data like "20141024X000000". First part before x is a date.
In another column(B) I want to format the date to become like "14-Oct-24"
What I did was use this function ...

**1**

vote

**0**answers

26 views

### Percentage increase between two data points - bar chart / Excel

Please forgive me but I simply do not know how to include these arrow lines displaying percentage increase/decrease between two points on a bar chart in excel. I wish to replicate what is showing in ...

**0**

votes

**0**answers

17 views

### Ideas on how to automate the export of cell values from 300 different excel workbooks

I have 300+ excel workbooks, containing some informaiton. I need to construct a dataset, containing information from each of the workbooks.
To clarify, let me give you an example:
-WB1.xls contains ...

**-1**

votes

**0**answers

16 views

### Why is Index and Match Formula showing incorrect value?

I am trying to pull some value from 2 combined column using this array formula.
{=INDEX($E$27:$E$35,MATCH(1,(H27=$B$27:$B$35)*(I27=$C$27:$C$35),0))}
The problem is the value shown is always ...

**0**

votes

**1**answer

24 views

### A chart where the line between points does not interpolate

I have an Excel spreadsheet showing the balance of a bank account over time. Each data-point is the balance of the account immediately after a transaction (so there might be several per day, with the ...

**0**

votes

**0**answers

11 views

### Highlight Track Changes

customize excel 2010 highlight track changes
The macro above thread doesn't have the option to undo. How to revise this?

**0**

votes

**0**answers

20 views

### Years on the X-axis on a Gantt chart created in Excel 2010

I'm trying to create a gantt chart in Excel 2010 but I have problems with the x-axis.
The chart shall show when 6 different steam engines were in service, at the workshop for revision between ...

**0**

votes

**1**answer

15 views

### Validating the “results” of the scrollbar in Excel

I have searched high and low, but found nowhere something that could help me.
Here is my problem:
I need to set a range of dates with two sliders. One slider sets the starting date of the examined ...

**1**

vote

**1**answer

76 views

### How to draw an excel chart from two columns?

Consider the following table:
1970 - 4705
1980 - 4771
1990 - 4998
2000 - 5181
2001 - 5195
2002 - 5205
The left number is x, the right is f(x). (The numbers are in separate excel columns)
I need to ...

**-1**

votes

**0**answers

17 views

### VBA macro doesn't work after reopening the Excel file

I have a sheet in my Excel where I made some "groups". I want to protect the sheet and still be able to open/close the groups (+/-). So therefore I have inserted this VBA code:
Private Sub ...

**0**

votes

**0**answers

22 views

### I am trying to make a pie chart that uses the most current quarter results and does not use previous quarter results

I would like to be able to display the most current quarter result for "Compliant, Non-Compliant, and Partial." That way I can feed the numbers into a pie chart for the most current status of each ...

**0**

votes

**1**answer

13 views

### can I create a PDF form that will export the questions and answers to an excel sheet

I want to create a form for my office that asks new clients several questions. I then want to export the filled out form to an existing excel sheet that has all of my clients' names and contact info ...

**0**

votes

**0**answers

35 views

### Convert Excel To Text Using Office and Command line

Is there any command line option to pass to Office's Excel so it can convert .xlsx files into .txt files without showing Excel's GUI?

**0**

votes

**1**answer

40 views

### Is there a way to autofill cells in Excel 2013 with keyboard shortcuts?

So very shortly, I want a shortcut equivalent to dragging the little handle in the right-bottom in a cell-selection portion in Excel 2013 (for Windows).
There is many similar questions on the site, ...

**1**

vote

**1**answer

22 views

### Excel file printing forcing margins

When I set my margins all to 0cm, and I have a portrait oriented page, the first top left cell in excel is like 2-3 mm from the top left corner of the page which is perfectly fine. However when I turn ...

**1**

vote

**1**answer

28 views

### Macro: Insert a new row above a cell containing a different numbers

I have an excel with two columns. Column A contains numbers and column B contains text data. Numbers are continuous like 1 2 3 with several blank cells between them as shown below. For example:
1 ...

**2**

votes

**2**answers

33 views

### Excel formula to populate from one column only if another is empty?

I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not ...

**1**

vote

**1**answer

27 views

### Excel links on rota [closed]

I have to do a rota that is currently done on two spreadsheets. One shows the member of staff where they are working the other tells us that where they are working has cover by a member of staff. ...

**1**

vote

**1**answer

27 views

### How to export full data from excel as a csv using macro?

I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data?
Here's my code:
Sub CSVFile()
Dim My_filenumber As Integer
Dim ...

**0**

votes

**1**answer

23 views

### Excel 2013 Display Values From A Table As Column Headers

I have a list of employee names in a one column table. I would like the values from the table to display dynamically as column headings on a single row in a different table.

**0**

votes

**0**answers

8 views

### How do I configure the plot area to display my entire series of data?

The simplest way to describe my question is to view this image:
When I click on the series (i.e. the bars, you can see that the "shadows" of the non displayed bars are displayed outside the plot ...

**0**

votes

**1**answer

19 views

### Hyperlinks in Cell Not Emplying Full Use of HTML

The following is on Excel 2013.
I have a spreadsheet that, through a VBA macro, takes a numerical input from a cell and appends it to a hyperlink to a PDF document on a website immediately after ...

**0**

votes

**0**answers

46 views

### Microsoft Excel Starter 2010

I have multiple columns/tables of data that I want to use in what I think would be an if/then formula BUT I have more than 2 options ie. I want to be able to type in a number (62111) and have it auto ...

**0**

votes

**0**answers

23 views

### Compatibility between Mac and PC Microsoft Office database

In my new job, we used a mailing service (tralix), and I have to upload a database, my boss had taught me hers way, (I'm working on Mac): I have to go to PC and open excel (she gave me the DB), and ...

**0**

votes

**0**answers

24 views

### Formula entered in a cell on sheet A referencing sheet B populates in sheet B

I'm seeing an error when entering formulae which reference another worksheet. This typically only happens with large workbooks.
Example: I have two sheets, DataSheet and OutputSheet. On OutputSheet I ...

**0**

votes

**2**answers

26 views

### Most Current Result

I have a spreadsheet that reports 3 number results by quarter. I would like to create a pie chart that will only use the most current information. For example it will use quarter 1 data if no other ...

**0**

votes

**3**answers

62 views

### Excel VBA or Formula to convert text to Date with Time type

I have a quite a number of data where its date/timestamp has been imported into excel as text. Excel does not really recognize it as date with time. e.g. 25.08.2011 16:17:59 (mm.dd.yyyy hh:mm:ss)
...

**0**

votes

**0**answers

14 views

### Excel/Google Sheets: NETWORKDAYS() over a filtered range

I'm currently cleaning up a Google Sheet, which due to increasing size needs to be condensed a bit. I'm currently working on removing 14 columns with basically the same formula, but am having problems ...

**0**

votes

**2**answers

27 views

### How i can calculate row in formula? making a link to specific cell

For example: Link to Cell A1 is "=A1"
A - column name
1 - row number
Can I calculate row number in formulas to make specific links?
Something like =A{some calculations} so =A{1+1} will be a link for ...

**0**

votes

**2**answers

54 views

### Excel: Output more (calculated) lines based on a single criteria

I want to split a single line of information when it meets certain criteria, into several.
In the attached example, I'd like to split the lines with a number of 2 or more in the "Records" column, ...

**0**

votes

**1**answer

34 views

### Track username and date who opened an Excel sheet

I'm using VBA to display a welcome message with the username. Additionally I want to keep track of the username (taken from environment variables), date and time in one of the sheets.
For example: ...

**1**

vote

**0**answers

34 views

### Text to copy cells with formatting into Excel

I am looking for a way to copy-paste text into Excel, which Excel will recognize as formatted (ie, styled or colored, etc) cells.
On the one hand, Excel recognizes tab-delimited text pasted from the ...

**1**

vote

**1**answer

42 views

### How do I delete " in every cell?

In my spreadsheet there are descriptions that use ".
For example
3" plates
I need to delete the " in all cells that it's in.

**1**

vote

**1**answer

44 views

### EXCEL - EXTRACTING Data From Multiple Worksheets where the layout is varied

I have a spreadsheet which contains Bill of material data and Labor costs for manufactured parts.
The first worksheet contains the master part numbers for the assemblies
Each Worksheet represents the ...

**0**

votes

**1**answer

15 views

### Refer to another worksheet that has increment in cell number

I have a worksheet (let me call it WorksheetA) that each row has a different information. Then, I want to refer this information per row on my other worksheet (WorksheetB).
To explain further, ...

**0**

votes

**1**answer

31 views

### MS Excel | how-to SUM combination of array/absolutevalue

When using Microsoft Excel you can use the SUM function to add multiple cells, like so:
=SUM(A1:B7)
Let's say Row-A is an array set of numbers per cell (numbers totalled by formula) and Row-B is ...

**0**

votes

**0**answers

15 views

### can I save a view of multiple worksheets in excel 2013

The image below is a view of two (2) worksheets in the same excel 2013 workbook. I made it using View--> View Side by Side, and the sizing each sheet, etc.
Is is possible to save this view so that ...

**0**

votes

**2**answers

38 views

### Get Last 5 Non-Zero Values in a Row

I have a large spreadsheet with many rows where the data can have zeros and positive/negative values but all numeric values. I would like to write a formula (or five formulas if needed) to tell me ...

**0**

votes

**1**answer

15 views

### Excel Chart Object without source data in Word going back to Excel

I have an Excel object chart in word. The chart is a line graph. The data is there because when I mouse over the line, I see each individual x and y value. However, the word file chart was sent to me. ...

**0**

votes

**1**answer

30 views

### Excel 2013: I need to go to last row in a table, go up 48 rows, then sum every 12th row

I know that I can use an offset/counta to get to the bottom, then go up a certain amount of rows. But if I use this with a sum, for example:
=SUM(OFFSET(M1,COUNTA(M:M)-47,0,12))
I will get a sum of ...

**0**

votes

**0**answers

18 views

### VBA code to paste value to an indexed position from a match on different sheet

I am struggling for days to make this excel formula work from a command button.
=IF(‘Machine Status’!E$28=(INDEX('Import Pool'!$A:$H,MATCH(‘Machine Status’!$B$23,'Import Pool'!$G:$G,1),2))
then cut ...

**-2**

votes

**0**answers

17 views

### Excel 2003 workbook and sheet damaged [closed]

I am facing problem with an excel workbook. Whenever am opening my data workbook am getting the following error: This file is not in a recognizable format
Any suggestions please!

**0**

votes

**1**answer

33 views

### How do I get a hyperlink open only one internet explorer window

How do I get a hyperlink open only one Internet Explorer window? It keeps opening the same thing from the link but in two IE windows.

**0**

votes

**1**answer

30 views

### excel copy past repeat macro

At the moment I am working on a research project for my university in excel. Now I have a certain range BF1:DJ293 which has to be copied and past for 238 times to the right. So this range has to be ...

**-2**

votes

**0**answers

27 views

### Add a “Submit” button to an excel sheet

I need to have this functionality in excel, wherein on clicking on "Submit" button in the sheet selects all text from a column and email them to a group of users.
For e.g--Column A has the following ...

**0**

votes

**1**answer

34 views

### Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...

**0**

votes

**0**answers

19 views

### Excel - How to get list text to display [duplicate]

How do I write this excel cell formula?
So I have a RowA which has a list of words and they each correspond to RowB with an "!" or an "X".
Row A : This is a list of words
Row B ...

**0**

votes

**1**answer

30 views

### Select text to display based on matching a symbol in another row

How do I write this excel cell formula?
In Row 1 is a list of words and they each correspond to an "!" or an "X" in Row 2. Only one word is given an "!".
[A] [B] [C] [D] [E] ...