**0**

votes

**1**answer

19 views

### Excel VBA localisation issue - WIN 8.1 Enterprise, Excel 2007

I have a problem with file using VBA macros created in GER version of Excel. This macro is testing the pivot table item for "Alle", but when someone opens the file in EN version, the pivot table item ...

**1**

vote

**1**answer

28 views

### Concatenating multiple characters with different formats in excel

I need to create a large series of multiple machine numbers with the following character formatting: Machine Number(first 4 digits)_Date(last 6 digits) as provided in the sample image below:
One ...

**0**

votes

**2**answers

35 views

### Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added

I have a big data set. What I want to happen is for each customer number occurrence, when the transaction type column has an entry CC or SO, it needs to be calculated as a donation. So for each ...

**1**

vote

**1**answer

16 views

### Excel automatic “date changed” field for each column of data

I'm using Windows Excel 2007, if that matters, and I'm trying to have a date field update to today's date automatically only when a cell in that column gets changed.
I add new data entries per column ...

**0**

votes

**1**answer

25 views

### Convert a column B into a comma separated list , “ORDER BY” Colum A

trying start with VB in excel
just need understand how it works , this task can be done in SQL,
but I really want to know how can be easy done in excel
column A contains par numbers , column b models ...

**0**

votes

**1**answer

21 views

### How to compare the Values in two different columns if the Values are same get the values

Column B has Values of customer Number (multiple times) till Row 1000 and column A has the sales orders information like below.
Column A Column B
ORDER1 KRISHNA
ORDER2 RAVI
...

**0**

votes

**0**answers

9 views

### How to merge Excel 2007 table with pre-existing Word 2007 table

Using Word 2007 and Excel 2007.
I have a client technical document that contain tables that have very specific formatting (borders, fonts, font colors) that I'm not allowed to change. The tables are ...

**0**

votes

**0**answers

10 views

### How to combine multiple databases in excel into one strong and efficient database

I'm working in a highly reputed government company as a data entry clerk and my responsibility is to keep the contact information database updated by adding new contacts and making sure that all the ...

**0**

votes

**2**answers

23 views

### Excel: Separate empty cells from having 0 value

I wanted to know if there is an option that doesn't allow empty number cells to obtain the 0 value when there is a function that takes values from these cells. For example, if I want to add the ...

**0**

votes

**1**answer

26 views

### How do I implement the VBA module to copy filtered data

I need to implement a VBA Macro that copies data from one excel worksheet and puts certain column into another one.
Sub sbCopyRangeToAnotherSheet()
'Method 1
Sheets("Sheet1").Range("A1:B10").Copy ...

**0**

votes

**0**answers

27 views

### Extract all URLs and emails from a single cell

I have an Excel workbook, in column A each cell contains lot of text and some URLs and emails (all this in one cell).
Among all the text within a single cell I want to extract all URLs and emails.
...

**0**

votes

**0**answers

18 views

### how to get cells containing keywords separated by a comma to become filter keywords on activating the filter

I have a table of recipes:
Dish | Ingredients | Tools |
Soup |tomatoes, basil|bowl, fork |
Pizza|eggs, cheese |pan, knife, plate|
Pie |meat, eggs, ham|skillet, knife |
If I ...

**0**

votes

**0**answers

17 views

### Excel Pulling details from sheet 2

How could we get the data from the Page 2 in same work sheet matching with data provided in sheet 1. But data with sheet 1 and sheet 2 matches nearly same not exact. Please suggest by the following ...

**0**

votes

**0**answers

23 views

### Excel split row into multiple rows

I am using Excel 2007. I want to split rows into multiple rows with one phone number on each row, so that it looks like rows 8-12 in the screenshot.

**6**

votes

**2**answers

341 views

### How to generate random string from a set of available strings in Excel?

I want to generate a column which will have random string values in any order. Those string values have to be from ('New', 'Mint', 'Very Good', 'Good', 'Acceptable', 'Poor') strings? Can anyone let me ...

**-1**

votes

**0**answers

20 views

### Why does pasting large number of additional rows into Excel 2007 table cause Excel to flicker as if continually recalculating?

I have an Excel 2007 xlsb workbook containing several Excel table (ListObject) objects, each holding reference data. Every month, each table is updated by pasting approx 2,000 additional rows of ...

**-1**

votes

**0**answers

11 views

### Security Alert - Office File Validation, Microsoft Office Excel Security Notice

I went into Regedit used that script and that didn't help, I went into gpedit.msc and appeared that a file was missing and that didn't work I went into Microsoft Office Backstage View and that also ...

**0**

votes

**1**answer

11 views

### Damaged / corrupted excel file ~$

I had a really important excel file saved with a lot of data on a external hard drive. Somebody unplugged the drive from my computer without safely removing the hardware. I was able to recover ...

**0**

votes

**1**answer

34 views

### How to compare column data in one spreadsheet to another

I have two Excel spreadsheets. One spreadsheet has two columns of numerical data. Column A and column B. Column A houses company codes and Column B houses Cost Centers associated with the company ...

**0**

votes

**0**answers

6 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

29 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

25 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, ...

**-1**

votes

**0**answers

31 views

### Create CSV from a formated table in Excel using Macro

I need a little help, I have a table in an Excel File, but I need to create differents CSV files according to when a field change in one column.
I need to create a different CSV each time that the ...

**0**

votes

**0**answers

16 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

**-2**

votes

**0**answers

15 views

### VBA - have a base in common and separates each sheet

I am a beginner with VBA, still trying to figure out this great tool.
I have a file wwith 30 sheets I need to save separately, but two needs to be always there.
For example
Sheet A - Needs to be ...

**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 ...

**1**

vote

**1**answer

42 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

29 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 ...

**1**

vote

**1**answer

33 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 ...

**0**

votes

**0**answers

21 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

30 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

17 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

31 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

60 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

20 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

56 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 = ...

**3**

votes

**1**answer

78 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

59 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

40 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

21 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

21 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

44 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

43 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

16 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

67 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

100 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

28 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

31 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

42 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 ...