**0**

votes

**2**answers

80 views

### referencing variable cells within the AVERAGE function

I am trying to create an automated system to average data, but the starting row and ending row of that data varies from one time to the next. I currently use the LOOKUP function to locate a reference ...

**0**

votes

**0**answers

12 views

### Linking data to chart using vba

I am trying to connect this data to my chart but i am getting application defined or object defined error
Dim chtObj As ChartObject
For Each chtObj In ActiveSheet.ChartObjects
chtObj.Delete
Next
...

**0**

votes

**2**answers

804 views

### Deleting charts in excel using vba

How to delete all charts in Excel Workbooks using VBA.
ActiveSheet.ChartObjects("Chart 3").Activate
ActiveChart.Parent.Delete

**0**

votes

**1**answer

67 views

### Condition Formatting error

I am unable use condition formatting using the code below, I don't know were I am going wrong here:
Sub condition_formatting_ms_sheet_test()
Application.Workbooks(file_name).Worksheets("ms")....

**0**

votes

**1**answer

28 views

### Excel Budget Spreadsheet Microsoft Word 2007

I have used a Microsoft Word 2007 annual budget spreadsheet template for budgets since they were .xlr. Npw they are .xlsx files and when I am working in them they take forever to process each entry ...

**0**

votes

**0**answers

11 views

### Excel, Ascending Workbook Default Filenames

Disclaimer: I'm very new to using VBA, so please bear with me!
I'm currently using the following macro to quickly export 4 specific pages from a larger workbook to a new workbook that gets emailed ...

**1**

vote

**1**answer

48 views

### How can I build a plot data in Excel without separating categories into multiple columns?

How can I plot the following data where each category is colored differently in excel?
category | datetime | score
--------------------------------------
foo | 2016-01-01 00:00:00 | 1
...

**2**

votes

**2**answers

28 views

### Unwrapped text won't flow into linked cells

I have linked cells that have text flowing to empty adjacent cells in the original.
In the destination sheet, the empty cells showed 0s and the flowed text disappeared.
Suppressing the 0s in Excel ...

**0**

votes

**1**answer

24 views

### ISBLANK not working as expected

I am using:
=IF(OR(ISBLANK(B9),ISBLANK(C9)), "", C9-B9)
To stop my data from returning a zero.
However the data that I need to return is the difference between two months =MONTH(L9)-MONTH(O9), ...

**0**

votes

**1**answer

77 views

### Using Min/Max function in excel how do I return a different value from the same row?

I've created a table (not using the table tool just using the cells) in Excel in one sheet.
In another sheet I have called the min/max function for that table to return the highest/lowest value.
...

**4**

votes

**2**answers

100 views

### Is there an add-on for Excel to allow me to sort by an arbitrary column with a SINGLE click?

Windows Explorer allows you to sort by an column by clicking on the 'header' of that column so you can see files sorted by size or filename etc.
Excel on the other hand forces you to go through the ...

**0**

votes

**2**answers

44 views

### Excel SaveAS RTF

Sometimes I need to save a block of cells in a worksheet in RTF format. I am using Excel 2007. I currently:
open an instance of Word
copy the cell bock from the worksheet
paste into Word
save the ...

**1**

vote

**2**answers

133 views

### Can't detect month “Jan” in excel table?

The reference no, e.g. EPS-I-S160201 is in the format of EPS-I-"Category""yy""mm""Sequence No"
Reference No is auto generated to run in sequence. The last 2 digits will auto reset the last 2 numbers ...

**0**

votes

**1**answer

26 views

### Using a Date to refer to a page to VLOOKUP into

I currently have data that has a date and item number and I'm looking to pull the price from a different sheet.
=Vlookup(#,Jan1!(Range),2,0)
Gives me my price of Jan 1
=Vlookup(#,Jan3!(Range),2,0)
...

**0**

votes

**1**answer

24 views

### Assigning Serial Number to Combination of cells selected from List

I have two columns(Column A and Column B) which are in LIST drop down form
A B
a 1
b 2
c 3
d 4
....so on
that means you can select "a" from column A and "2" from column B ...

**1**

vote

**0**answers

45 views

### SUM nested values based on nesting level labels [closed]

I have a manufacturing process, which has costs for raw materials and processing steps. Level 1 is the finished product. Its cost is composed of level 2 materials and processes. Some of the level 2 ...

**0**

votes

**0**answers

30 views

### Two sheets need to have matching data

I'll do my best to put this simply.
Let's say I have two sheets with the same table formatting. Both have columns "ID" and "Fruit". One of the sheets has missing fruit names, but still has all of the ...

**-2**

votes

**2**answers

36 views

### i would like to be able to type a number in a column & autofill the address in the next column

I have a workbook where I have a column 'site no.' where I'd like to be able to type a 3 digit number & the column 'site address' is auto filled with the address. site numbers & site address's ...

**3**

votes

**0**answers

71 views

### Checkbox location changes when workbook is opened in Excel 2010

I am using Excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell.
When I open it at work with Excel 2010, all the ...

**2**

votes

**3**answers

255 views

### How do I restart a number count if Cell value = 0

Been looking how to do this all day.
I am trying to get an auto reset if a cell hits 0 but I just cannot find the formula or VBA to help achieve this.
A1 9
B1 9
C1 0
D1 9
E1 9
F1 9
G1 9
H1 36 (I ...

**2**

votes

**1**answer

23 views

### Delete input field from Excel 2007

How can I delete an input field from Excel 2007?
Note that copying the content of the page without selecting the input is not an acceptable answer.

**0**

votes

**0**answers

47 views

### Can you use unit of measurement combinations with Excel's CONVERT function, and if so, how?

I've been wanting to experiment more with Excel's CONVERT function and came across a useful web page that listed the proper syntax required for it. The url to the page is below:
https://support....

**0**

votes

**0**answers

40 views

### What is the most efficient way to standardize time formats and find time durations exceeding specific lengths using Excel 2007?

THE SCENARIO: Let’s say somebody hands you a spreadsheet containing a column for the time duration of 416,000 videos. When the information was entered, it was entered into an Excel 2007 spreadsheet ...

**0**

votes

**0**answers

37 views

### Formula to find difference/change between 3 or more fields?

Probably a dumb question, but I'm looking to find the difference between 3 values in excel.
+-----------+-----------+-----------+
| Nov. 2015 | Dec. 2015 | Jan. 2016 |
+-----------+-----------+------...

**0**

votes

**1**answer

30 views

### How to fill a cell according to the type of number

Currently I have 2 suppliers with barcode scanning system in excel. Since I scan them in Column A in excel (with auto-enter to the next cell), I would like to know if it is possible to have ...

**0**

votes

**0**answers

30 views

### Excel 2007 backup spreadsheet without formulas

I have a spreadsheet report that refers to multiple other workbooks to update values.
Currently no macro is used, spreadsheet depends on cell references to update the values.
I need to do a daily ...

**0**

votes

**3**answers

73 views

### Filling cells with sequential numbers in an Excel (2007) spreadsheet as a noob

I need to fill an excel column with a sequential series, in this case from 1 to 31. As a complete noob I've no idea what a macro is so the answers on "Filling cells with sequential numbers in an Excel ...

**1**

vote

**1**answer

82 views

### How to implement answer to: “How to get excel row numbers to skip the header”

The question How to get excel row numbers to skip the header asks about how to change the way Excel numbers its rows. The author's usual practice was to use Row 1 for column headers and wanted to ...

**0**

votes

**0**answers

31 views

### Auto filter with multiple criteria and display data if anyone of the criteria met in the table

I'm trying to filter an excel table based on four criteria and using the below code for it.
Range("A17").AutoFilter field:=8, Criteria1:="=" & a, field:=6, Criteria2:="=" & b,field:=7, ...

**0**

votes

**1**answer

15 views

### Excel 2007 I need to be able to enter data in a cell on one sheet and have that populate on a different sheet

Thank you in advance, I am attempting to have a workbook that on the 1st sheet has cells that I need to populate with the data I enter on the 2nd sheet.
There is no calculations that will be performed ...

**0**

votes

**2**answers

64 views

### How to put comma into digits like eastern (especially Indian) style by using a formula in M S Excel?

Friends I want to put comma automatically into the digits like this-
10,00,000
Or
1,00,000
For this I want to use a formula. I also know that I can do this by format cell>number>use 1000 separator (,...

**0**

votes

**2**answers

203 views

### Excel Personal Macro Workbook keeps getting disabled

I'm a new user to this site. I'm trying to run a VBA macro in Excel once a day at midnight using the windows task scheduler. It imports data from a .txt file that gets dropped into a folder at night, ...

**0**

votes

**1**answer

38 views

### Comparing 2 columns and add blanks in 2nd column

I have 2 columns where some cells have the same value.
I would like to sort both columns and put blank cells to another column if it doesn't have duplication.
Example:
| Test1 | Test1 |
| Test2 | ...

**1**

vote

**1**answer

39 views

### what is the purpose of Print Scaling in the page layout tab in Excel?

What is the purpose of Print Scaling in the page layout tab in Excel?
in the Width and Height I can select Automatic and options like 1 or 2 pages and others. but I don't know its purpose.
Is it ...

**0**

votes

**0**answers

14 views

### Microsoft Excel 2007 for OC

I have a column with multiples of different answers, like the following:
Country
Germany
US
Italy
Italy
Germany
Germany
Germany
US
Italy
US
I want to:
list how many different countries are in ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

51 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

161 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

91 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

36 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

110 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

14 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

50 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

101 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

733 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

59 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

28 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

21 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

64 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

1k 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 ...