**0**

votes

**0**answers

8 views

### Excel 2007 run a macro by clicking a cell [duplicate]

Really simple, I would like to click a cell on a spreadsheet and have it run a macro.
tried building code but it doesn't activate the macro.
Sub scroll_Bar_update()
If Target.Address = "$F$1" Then
...

**0**

votes

**1**answer

63 views

### Show current workbook name in a cell

I am trying to view the name of the file that I am working on in Excel. I would like to use a formula to return the file name to a cell on the spreadsheet. For example, if the file was called ...

**0**

votes

**0**answers

26 views

### I need help on duplicating Excel sheet

I am preparing a student report card. I have a sheet called (ENTRY) which contains the student's names in column and marks for the various subjects they wrote in corresponding rows like this:
Now, ...

**0**

votes

**0**answers

18 views

### If for a given text criteria, there are multiple text results, is it possible to get the results in a single row, horizontally against that criteria

1 abc
1 bcd
1 cde
2 def
2 ghi
2 hij
3 efg
4 fgh
How can i get the information in the below format, by using an excel formula
1 abc bcd cde
2
3
4

**0**

votes

**0**answers

15 views

### How to write pi with more than 15 decimals in Excel? [duplicate]

I would like to know how to write the pi number with more than 15 decimals with excel, by instance with 30 or 40 or 50. Or is there any (free) program that could calculate numbers with as many ...

**3**

votes

**1**answer

68 views

### Apply an Excel VBA function to many files

I have an Excel VBA function and around 30 files with data (and the same data structure) to which I would like to apply the function to.
My approach would be to write a macro in a separate Excel file ...

**0**

votes

**0**answers

166 views

### Recover xlsx document from temp file

I have formatted one of my PCs, then I discoverded that I haven't done a backup for an .xlsx (Excel 2007) document. I did a recovery using Recuva and I got two files with the name I searched for (...

**2**

votes

**1**answer

139 views

### Extract bold value from cell in Microsoft Excel (2007)

I have a spreadsheet in which cells contain values one of which is bold. (It's a list of tickers, the bold one is the main ticker for the company.) I would like to extract the bold value from the cell....

**0**

votes

**0**answers

29 views

### Excel dynamic range selection and look up

There is a list of unique identifiers. The list is dynamic (one day it has 7 and another day it has 17).
Based on this list, we download data related to those identifiers in another sheet.
This ...

**0**

votes

**2**answers

63 views

### How can I copy each worksheet into a new workbook and preserve formatting

As in my title.. I have the following code:
Sub SaveSheets(yeard, monthd)
Dim strPath As String
Dim ws As Worksheet
Application.ScreenUpdating = False
strPath = ActiveWorkbook.Path & "\" & ...

**0**

votes

**0**answers

104 views

### Listbox, mouse wheel scroll issue

Whenever I try scrolling through list Box created by Excel Vba , using mouse wheel . Excel sheet tend to freeze up .
have any one experienced the same ?
Excel version that I am using is 2007.

**-1**

votes

**1**answer

206 views

### In Excel is there a way to copy and paste from one column to another when there are filters? [closed]

When there is filter which give discontinued numbered visible rows, Excel usual copy and paste does not work for all visible rows : you have to copy and paste multiple times.
Is there a way to do ...

**0**

votes

**1**answer

882 views

### EXCEL: How to Search multiple files for value corresponding to text in same row?

I know this is a blatant help me post, but I have been given this task and I don't know how to get it done in time.
I have moderate knowledge of excel, but I dont know any VBA. I have learnt C++ so ...

**0**

votes

**0**answers

15 views

### Inserting Another Files Information into Excel (last few characters are always changing)

I'm not sure if excel can even do this but I have created a file (Top 3 Sort) and I am working on creating a macro to pull information in from other files and put them into a formula {this part I ...

**0**

votes

**1**answer

31 views

### Excel Lookup for work sheet comparison

I have 3 sheets. The first one contains data for Shop A, the second data for Shop B, and the last sheet contains the results.
Sheet A & B: Item Code, Name, Brand,and Stock
I want to compare ...

**0**

votes

**1**answer

213 views

### how to generate serial number for each selection in combobox in excel vba

Private Sub CommandButton1_Click()
With ComboBox1.Value
Dim a, b As String
Dim i, j, k, l, x, q, m, temp As Long
a = ComboBox1.Text
i = Application....

**4**

votes

**1**answer

1k views

### Which Excel objects are zero-based and which are one-based?

Using VBA to access the first sheet in a worksheet is Worksheets(1). The first item in a ListBox is myListBox.List(0). I heard that Collections are 1-based but I don't know what they are. VBA arrays ...

**1**

vote

**1**answer

66 views

### How to make Excel macro shorter?

Here’s what my code does:
It looks for duplicate entries in column A. It applies color to both the cells when a duplicate is found.
What I’m trying to achieve:
Reduce amount of code
Make it short ...

**0**

votes

**1**answer

93 views

### How to insert Time in a range of excel sheet which should not update automatically?

Friends I want to insert time in a range which should not get updated automatically. For example if there is any value in cell no k5 then the current time should automatically be inserted in cell no ...

**0**

votes

**1**answer

25 views

### creating a functional array to store names of files in a folder

i want to create a functional array that stores all name of file in perticular folder
this is what i tried..
Function number_of_file(i As Integer) As Variant
Dim file_object As Object
Dim ...

**0**

votes

**0**answers

27 views

### Rounding up from a list of values / Returning a value from a table in Excel

I have already worked out 1 variable in a Spreadsheet (In this case it's the "AREA OF STEEL REINFORCEMENT") but it needs rounding up to a specific value given in a table.
Firstly though an input ...

**0**

votes

**1**answer

113 views

### How do I delete repeated values (#Not remove duplicate values#) in a column excel?

I have the following two columns of data:
Location Value
A 1
A 1
B 2
C 2
D 3
D 3
E 4
E 4
F ...

**0**

votes

**1**answer

54 views

### Identify bad meter readings in Excel [closed]

I have a series of meter readings sent in by field techs that tend to have finger checks & provide absolutely bizarre readings. Do you have any idea how I can identify the "Bad" meter readings ...

**0**

votes

**0**answers

35 views

### Alternative option for select * from

In the Excel database query we will use the below syntax to define a reference value
SELECT * FROM [Sheet1$A1:Z500] where Dept = 'IT'
In the above case I am taking the Dept value IT as a reference ...

**0**

votes

**3**answers

183 views

### How can I get the unique values present in a column for each set of identical values in another column?

I have the following two columns:
Con.By Prod
A 1
A 1
A 2
A 2
B 1
B 1
B 2
B 2
I can easily get the unique values either in column Con.By or ...

**1**

vote

**0**answers

2k views

### How can I create sub-sheets in Microsoft Excel?

I have a workbook in excel that displays information from multiple processes and each of these processes has multiple sub-processes.
I can display information for each process easily using one sheet ...

**-1**

votes

**1**answer

46 views

### Outlook 2013, and Excel 2007

Currently when clicking on an .xls or .xlsx file it opens in Excel 2007 fine.
However when clicking on a .xlsx attachment in Outlook 2013 it opens in Excel 2013.
Is there a way to force Excel ...

**-1**

votes

**1**answer

35 views

### Need help to find a solution for excel spreadsheet 2010

Example:
Column A Column B Column C Column D Column E
Maricar Gener Adriel 3 (It's like an auto sum)
Jocelyn Gener ...

**0**

votes

**1**answer

118 views

### Pop Up Message On Excel Cell

I would like to have a pop-up message to remind the user to proceed to section iii to complete the rest of the input.
I attempt to use Data Validation>Input Message but the message is always there. ...

**0**

votes

**1**answer

43 views

### Running excel line graph

I have a set of data points in a spreadsheet with another set of line graphs plotting that data over time. New data in entered every month and each month I have to manually update the charts to ...

**0**

votes

**0**answers

26 views

### Excel Icons for matching cell size

The old Excel had two icons - one for columns and one for rows. Clicking one of these would automatically match the size of all the columns and go all the way across or down the page. I am now using ...

**0**

votes

**2**answers

46 views

### Excel Indirect #ref error [closed]

Trying to use the INDIRECT formula to pull a summary at the end of a large workbook. I have listed the Worksheet names in a single tab and now wish to use these to pull specific cell data into a ...

**1**

vote

**0**answers

25 views

### Control Number Generation

So currently I have the following. When I click a button or hit submit button The form looks on the Ledger Tab. I was trying to get the form to automatically generate a control number (ConNum) that ...

**0**

votes

**0**answers

16 views

### Referencing in Excel

I have 2 excel spreadsheets and I need to reference data from 1 sheet to another. That is simple enough but this is where it gets complicated.
Sheet 1 is my reference sheet and sheet 2 is my formula ...

**0**

votes

**2**answers

193 views

### How can I select and output the first and last row of a worksheet or a filtered list?

I am new to VBA and I have no clue where to start with this.
I have two columns of data:
Team Member Time
A 1
A 2
A 3
A 4
I am only interested in ...

**0**

votes

**0**answers

308 views

### Install older version of MS Office without removing newer version first

I'm currently running Microsoft Office 2010, but I temporarily need Excel 2007. I know I can use the Custom setup at the 2007 install process to select just Excel, and based on the Setup Help page:
...

**-2**

votes

**1**answer

62 views

### Need to scrape data from notepad and convert to excel. Need any software or excel formulas

TEXT FORMAT Below:
October 9, 2013 Williams J G ODROMA55@HOTMAIL. COM Julie M Riveness 64 Massey PI SW Prince
Rupert BC 4032533446 6414674117 Evening Z496277 ...

**0**

votes

**1**answer

50 views

### Need VBA Code to Combine Rows if rows A-F are the same

I need a VBA code that will combine rows if, for instance, Rows 4 & 5 have the same values in columns A:F. However, then I need for Column G to be split. G4 stays as G4 but then G5 becomes H5. I'...

**3**

votes

**1**answer

200 views

### How to remove a macro button added by customized ribbon in home tab?

I have added a macro button in an excel sheet by customize ribbon and have assigned some VBA code to it to do some particular task. The problem is that when I open any new workbook, Excel shows that ...

**0**

votes

**1**answer

100 views

### How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted.
I am using conditional formatting's "use a formula ...

**0**

votes

**2**answers

91 views

### If multiple cells are with the same text, return this text(value) to another cell

I need your help with this:
If A1:E1 is "Red", return "Red" to C3;
If A1:E1 is "Blue", return "Blue" to C3;
BUT
If A1:E1 are not the same, return False or "X" to C3
What function to use ...

**3**

votes

**1**answer

1k views

### Excel Large Function with Duplicates

I'm trying to apply a LARGE function to get the 5 largest values from a column ignoring duplicates. I did some searching around and found some proposed solutions but they don't seem to work for me. In ...

**3**

votes

**1**answer

93 views

### Autofit row height in Excel 2007

Using Excel 2007. Attempting to insert photo in each row and a specific column, but when the picture is inserted the row doesn't adjust to the height of the photo. I've tried selecting the row and ...

**0**

votes

**2**answers

134 views

### Excel: check if two cells have specific content and show true/false in another

I have a large datasheet with multiple columns. Long story short, my columns A and B (of text type) are lists of codes. For simplicity's sake let's say column A is days of the week, while column B is ...

**0**

votes

**1**answer

126 views

### Convert row with several columns into several rows with one column each

I have a very long list of data that looks like this:
User1 Item1 Item2 Item3
User2 Item1 Item2 #NUM! (This is a failed formula)
User3 Item1 #NUM! #NUM!
And I want to ...

**1**

vote

**2**answers

223 views

### Excel: using 2 cells to collect data from a list

My Example is this:
(workbook name"Rev)
letter weekly bi-weekly monthly
a 100 200 400
b 110 250 500
c 111 300 600
d 112 350 700
e ...

**0**

votes

**0**answers

28 views

### Matching words from two title and calculate %

I was trying to automate an Excel file which has title in both A and B columns and I have to search each word from A within B and calculate the % by using the "no of words matched/total no of words (...

**61**

votes

**2**answers

3k views

### Excel - can I set a cell to equal a certain value, no matter what is typed in it?

This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell (...

**1**

vote

**1**answer

66 views

### Excel 07: Sum Cells of Column B By Date in Column A And Report To Cell C

So basically I have a worksheet like so,
The data is manually entered in, column A is the date, the values are column E. Everything else is arbitrary and filled with x's. Basically what I want to ...

**0**

votes

**1**answer

66 views

### How can I convert colums to rows in Excel? [duplicate]

Below is a sample of a spreadsheet I have (fig 1). It has been exported from an asset tracking system and provides me a list of information about the hardware we have.
Each asset "area" uses the same ...