# Tagged Questions

**0**

votes

**1**answer

18 views

### User Input to Select and Fill In value for Cells

I have this excel table: A2 to A11 are class names Class_1, Class_2,..., Class_10.
B1 to K1 are student name 1,2,3,...,10
For each student in his class, I will need to fill out his grade
I would ...

**1**

vote

**1**answer

21 views

### Excel automaticly adding an extra row which already contain formulas for the inputed number of years

I am looking to build a model, I would like is have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...

**0**

votes

**1**answer

29 views

### Using VBA to calculate unique random numbers in “i” number of rows

I am currently working on a pet project of mine. I am currently making a combat calculator for a gaming group I DM. Essentially, I have a table with the monsters and their stats, and a cell with the ...

**1**

vote

**0**answers

14 views

### Adding numbers based on their relative position in a worksheet

I have nearly 10,000 numbers arranged on an excel worksheet to form the map of USA.
Now I want to separately add the numbers based on below mentioned four criteria:
1.0 Corner cells i.e cells flanked ...

**0**

votes

**1**answer

23 views

### Timestamp in Excel…not working?

I know this question has been asked numerous times, and I have truly searched and attempted to work it out with the given solutions to no avail. Maybe I'm doing something wrong, but I don't know much ...

**0**

votes

**1**answer

35 views

### Excel Pivot Table - How to preserve Filter and Sorting when Data get refreshed

I have a pivot table (Excel 2010). Every Time when I update the data and make a refresh, the sorting and filters of the Pivot Table get lost repsectively I need to explicitely to modify the filter ...

**1**

vote

**0**answers

30 views

### Excel VBA - User Defined Function to turn string into formula

I'm looking for something similar to the solution posted here:
Excel function that evaluates a string as if it were a formula?
Problem is this does not seem to work with a function in there.
This ...

**0**

votes

**1**answer

23 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**-1**

votes

**1**answer

25 views

### Excel: Averaging Sensor Data by Time Stamp

I have a device that collects temperature measurements from several sensors at discreet time intervals. This data is dumped into a .csv file with each row formatted as: [time] [sensor name] ...

**0**

votes

**1**answer

67 views

### Merging multiple excel files in to one file

This is my macro for merging all the files in one directory to one excel sheet. I am unable to find why its not working as per expectation. I have thousand rows in each file. It copies 1000 rows from ...

**1**

vote

**1**answer

30 views

### Automatically “comment out” formula in Excel?

So I have this result set in MS SQL Management Studio. And I have an Excel sheet. I copy and paste data from MSSMS to Excel. As far as good.
Now, some of the fields start with an equals sign. Excel ...

**-1**

votes

**1**answer

451 views

### How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach.
Basically as i stated in the title i need to write a macro that will copy the selected row or ...

**0**

votes

**0**answers

31 views

### VBA Compare columns on two diff worksheets, find in 2nd and group on 2nd worksheet

Excel 2010
Hi. I have a 6,000 line spreadsheet and need to group the lines, based on identified roll up points in another spreadsheet (150 roll up points). I want to be able to see the summary ...

**0**

votes

**0**answers

72 views

### VBA: how to color rows based on value in a spesific column - Coloring wrong sheet

I've been struggling with this for a while now. I need to color rows in Excel sheet 6 based on the value in column F. Everything works fine except the code is coloring the rows in Excel sheet 1! Help?
...

**2**

votes

**1**answer

95 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**0**

votes

**0**answers

23 views

### Creating an Excel Search Box which Unhides a Row

I've never done VBA before and I'm pretty sure that's the only way to achieve what I need. I have a master password list which I don't want people to see when they are looking at my computer. ...

**0**

votes

**0**answers

168 views

### VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...

**0**

votes

**1**answer

26 views

### Filtering out (blank) within a PivotFiled from all pivottables in a workbook that have the same pivotfields

I have a bunch (14) of pivottables in two worksheets (7 in each worksheet).
I have a refresh button on the sheet that refreshes all pivottables using the following code:
Sub Refresh_Pivots()
Dim pt ...

**3**

votes

**1**answer

162 views

### show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown.
Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...

**1**

vote

**2**answers

60 views

### Excel 2010: Calculate full months between dates

I have dates in two columns and I would need to calculate amount of full months between two dates.
I export the spreadsheet from SAP ERP in .xls format but opening with Excel 2010. DATEDIF function ...

**0**

votes

**0**answers

114 views

### Split Excel worksheet into multiple worksheets based on a column with VBA (Redux)

I'm rather new to VBA and I've been working with the code generously displayed and explained by Nixda:
Split Excel Worksheet...
My only challenge is I've been trying desperately to find a way to ...

**0**

votes

**1**answer

48 views

### Convert formulas in table to structural references

I have converted my range in excel 2010 into a table. However, the formulas which were before like that(see below) stayed the same and do not convert into structural references.
...

**0**

votes

**2**answers

29 views

### Showing name of row instead of excel cell name

I am having extremely long formulas over an extremely big sheet. At the moment I am tracking the formulas with the Formula Auditing Tool. However, my idea would be to just replace for example in a ...

**-1**

votes

**1**answer

177 views

### Compare the value change of data in Excel between two similar sheets without VBA?

I need to match data in the column A's of two different sheets with similar data and then compare the values in column C. sheet 1 features data from this month, sheet 2 from last month.
I have column ...

**0**

votes

**1**answer

66 views

### Months and Date keep being switched around when running VBA

I have a column on my sheet, Column F which is full of dates. Now I need these dates to be in this format "dd,mm,yyyy" but sometimes they are in text form, us/armenian format in the original data. Why ...

**1**

vote

**1**answer

52 views

### Clear contents from matched column of data in another sheet

I have a column of email addresses on sheet 2 col A (but I could put them on sheet 1 if it would make it easier / faster) that I want to remove from sheet 1 col D if matched (there may be 2 or more ...

**-1**

votes

**1**answer

78 views

### How to re-arrange Excel database from 1 long row, into 3 short rows of unequal lengths and automatically repeat the process?

This question is an extension/continuation of my previous question at How to re-arrange Excel database from 1 long row, into 3 short rows and automatically repeat the process? which was answered by ...

**0**

votes

**1**answer

111 views

### Set default expand/colapse state on pivot tables

The Setup
I have a pivot table in tabular form pulling data from an Analysis Services Cube.
I want to calculate the number of days between two dates, but the setup will only allow me to pull in all ...

**1**

vote

**0**answers

60 views

### Weird Excel 2010 VBA Window Behaviour

If I open Excel and then open the VBA window then close it, every time I RDP to my computer, the VBA window is open again, even if I closed it before disconnecting.
The next time I am sat locally to ...

**0**

votes

**1**answer

162 views

### VBA Solution to VLOOKUP with Hyperlinks

I am looking for some help with a VBA solution for preserving hyperlinks when using VLOOKUP on Excel (2010).
I have a load of data on Sheet 1 for internal use only, and a cut-down version of this ...

**1**

vote

**1**answer

240 views

### Hide/Unhide rows based on more than one cell value

Please help me
I am using the following code to hide rows if cell values are 0:
Private Sub Worksheet_Calculate()
Dim LastRow As Long, c As Range
Application.EnableEvents = False
LastRow = ...

**0**

votes

**1**answer

95 views

### How to re-arrange Excel database from 1 long row, into 3 short rows and automatically repeat the process?

I would appreciate help on the above-mentioned topic.
I am unfamiliar with Visual Basic for Excel, so will need step-by-step guidance (if solution is via Visual Basic).
For example :-
Row 1, Sheet A:
...

**4**

votes

**1**answer

728 views

### Add/Subtract button Excel VBA

Here is an example of my project in this picture
I like collecting, so I am making an inventory sheet in Excel.
I want to make a way that I can click a button and it affects the next, or previous ...

**1**

vote

**2**answers

1k views

### Searching for a value in Excel, returning yes or no

I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...

**0**

votes

**2**answers

192 views

### Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data.
I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...

**0**

votes

**1**answer

101 views

### VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function.
The purpose of the macro is after ...

**1**

vote

**1**answer

41 views

### VBA change Script on multiple tables

Via this forum I found a way to refresh autofilters in a table automatically after the data in a excel worksheet has changed, using this VBA script:
Private Sub Worksheet_Change(ByVal Target As ...

**1**

vote

**1**answer

107 views

### Excel - Change cell colour based on a date in the comment or mixed in with text

I am using excel 2010 and I am trying to set up a rule that will change the colour of a cell based on a date within that cell.
For example the cell may contain Site meeting - 11.05.14
I would like ...

**0**

votes

**3**answers

64 views

### Reformat data through macro excel 2010?

I am trying to create a macro that allows me to change the data I received from a client into data I can import into a system. The data I receive is in the format:
How Can I do this through VBA ...

**1**

vote

**1**answer

68 views

### Automatically sorting a range of cells after one cell within the range has been modified?

I have a number of named vertical ranges on a spreadsheet, containing lists of names. New names are usually manually added at the very end of each list. Obviously, this means that unless manually ...

**1**

vote

**2**answers

320 views

### Align Secondary Axis Origin with Primary

I am interested in aligning my secondary axis such that it lines up exactly with my primary axis.
To be more clear, I want the origins to both line up at 0 at the same place, each preserving their ...

**0**

votes

**0**answers

67 views

### Convert OO4 ODS to XLSX using Excel 2010 VBA

I am trying to bulk convert OpenOffice documents to Microsoft Office. Using built-in VBA, I use the following code (ODS to XLSX is shown, but same code is being used for ODT and ODP with some ...

**-1**

votes

**1**answer

38 views

### Format of Row in VBA based on 1stCell and also Compare to above row?

I was wondering how would i through VBA conditionally format the whole row or a row in a range based on the first cell in that row? Also it would require a comparison to the previous row to current ...

**1**

vote

**1**answer

44 views

### Searching the string in a text sitting on 1 coulmn

I'm very new into VBA coding, I would like to have some assistance as I have been trying for two days, I have got data fixed in column A, I would like to search for a string in that column, eg ...

**0**

votes

**0**answers

12 views

### Change font of cell automatically without changing font of text already placed in the cell - Excel 2010

I would like to be able to have the font automatically change color when double clicking on the cell without changing the font of the text that is already in the cell. Is that possible?

**0**

votes

**1**answer

69 views

### Is this possible in Excel? (VBA)

I want to create a VBA macro that will do the following:
The Excel file with the Macro should only open when the file is opened from a certain folder in the Windows directory.
If it is not opened ...

**0**

votes

**1**answer

145 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**0**

votes

**1**answer

69 views

### How to combine several excel workbooks into a single book

I have several, multi-sheet workbooks which I would like to combine so that I can search them all simultaneously. So, the merged workbook will contain tabs 1,2,3, of the first workbook, then tabs ...

**0**

votes

**3**answers

54 views

### Excel: Classifiying data based on a bin system

I'm working with excel 2010 on windows, am a novice excel user but I can program, so you are welcome to throw VBA at me.
I have a series of cells where a user can enter a number and another cell needs ...

**1**

vote

**1**answer

84 views

### VBA Excel: Error during range selection during workbooks iteration

I have several files in one folder with the column "Part Number" but not all of them are in the same column number. The list doesn't necessarily start in the same row either.
So I first look for the ...