**0**

votes

**3**answers

31 views

### Printing multiple sheets with Mail Merge (Excel/Word)

I need to create letters with MS Word. On each letter we need a code which is placed on the letter using Mail Merge. Some letters need to be printed more often than others. I need to find a way to ...

**0**

votes

**1**answer

36 views

### Change color of row according to column value (by regex)

I'm quite new to excel so this could be dumb question. I need to change color for those rows which has suffix .com in their second column. I use OpenOffice but I can change it using Microsoft Excel ...

**0**

votes

**1**answer

21 views

### Microsoft Excel spreadsheet to JSON?

I would like to create a JSON file from an Microsoft Excel (.xlsx). The sheet has all of the cells a certain height and width. I would like to have the top of each column be titled and used as a key ...

**3**

votes

**1**answer

25 views

### Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget.
Cells look like this
A B C D
DATE WEEKLY BILLS TOTAL
2015 $50 $1,956.73
Jan ...

**0**

votes

**3**answers

40 views

### highlight birthday in a referenced cell

in Excel 2003
in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday
in cell A1 date of Birth
in cell B1 age with the formula:
=DATEDIF($A1,TODAY(),"Y") ...

**0**

votes

**0**answers

14 views

### EXCEL macro opens document but does not ask to “update links”

I have an WORD doc with links to cells in an EXCEL document
If I open the linked document manually, it asks to [Update automatic links] and works perfectly but, when I use the macro
...

**2**

votes

**1**answer

25 views

### Cells evaluated by user-defined module do not update automatically

I read the questions existing but no answer seemed to help. I have a function I wrote in VB which evaluates sum of cells in a certain range by font color, it all works well when I type the function in ...

**0**

votes

**0**answers

22 views

### Excel will not put information in cell? [on hold]

I am entering data in one cell in excel and it will not put information in the cell. Will work in all others however. Started when I was simply trying to cut and paste a confirmation number.Number do ...

**1**

vote

**0**answers

29 views

### Shortcut for Direction Keys — To keep hands on QWERTY end of the keyboard

I use a lot of Excel and finally got myself used to the ThinkPad pointer whereby I no longer need to take my hands off the keyboard for scrolling.
But now I need to take my right hand off the ...

**1**

vote

**1**answer

25 views

### How to grep summarized value from excel cell range?

I want to get summarize information from the following sheet. I don't know how to summarize this information.
My scenario is like this.
If I input -6, I want to find my target value in this ...

**-1**

votes

**1**answer

57 views

### how do assign numbers to text and then add or subtract them?

How can I create a formula for the following spread heet?
The text all have same value (AB=1) BC=1) (CD=1) etc. I want to place the text in a cell to place order, the text should give me total number ...

**0**

votes

**1**answer

17 views

### View code in Excel - Import_Journals

I'm trying to look at some VB code in an Excel macro. This code is executed on a button click:
Private Sub ImportSelected_Click()
Call Import_Journals("SELECTED", "IMPORT")
End Sub
I want to ...

**-1**

votes

**0**answers

23 views

### How can I automate the process of printing 2 rows of data from one sheet after pasting it onto the form on another sheet?

Sheet 1 of my spreadsheet has the following form:
A B C D
They are just columns named 'A','B','C' and 'D'.
Sheet 2 has the following data:
A
1
2
3
4
5
6
7
8
9
10
I want to print pages of ...

**0**

votes

**0**answers

21 views

### Replacement of a string in excel with another string, taken from a csv file [closed]

Say I have a CSV file which looks like
"5.2", "Blah Blah Blah"
"5.3", "Bleh"
"5.4a", "Unicorns"
Now, how would I go about creating a script or macro of sorts(?) so that whenever I type ...

**0**

votes

**1**answer

22 views

### Clamping values while averaging

I have two formulas that are calculated using the same dataset. One formula calculates the average of the values, while the other calculates an average with a maximum allowed value of 60. I'm ...

**0**

votes

**1**answer

31 views

### Excel Updates Link In Other Workbook

I opened two spreadsheets from an email, spreadsheet June & November. Both June & November in cell A1 reference a [CashInput.xlsx]CashInput$A$1 that was saved on the spreadsheet creator's hard ...

**0**

votes

**0**answers

32 views

### Split single row into multiple rows in excel [duplicate]

I have a file of data formatted in the following way
contractID, typeofreview, rq#, q1,q1a, q2, q2a, q3, q3a, q4, q4a
0001 basic 15 Ht Y Smk Y Sur Y Rsk Y
0001 ...

**0**

votes

**2**answers

36 views

### How can I find the Maximum of Polynomial Trendline?

I have a XY chart.
I used a polynomial trendline, now I need to find the maximum of the chart in an automatic way.
Is it possible?
Here is a picture to show the type of chart.

**0**

votes

**1**answer

30 views

### Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file.
I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...

**0**

votes

**0**answers

29 views

### Group different values with same name field in Excel

I'm having troubles with the following document.
Is there a way to group different values with the same name field?

**2**

votes

**1**answer

29 views

### VBA EXcel - I am getting an error (400) if using error trap getting no object/application defined error

My excel sheet has these data, 7 columns
sl.no | bed | 2| 4| 3|4|3|
some times column no 7 is empty, and then only I'm getting error
And my code
Sub sup_cal_area_sft()
Dim lru, plru As Long
Dim ...

**0**

votes

**1**answer

22 views

### Color a cell in MS Excel sheet, if do not fall in range

We need to enter lots of data in a excel sheet. Later we want to color code that data.
I will be the one preparing this excel sheet and sharing with team. What I want is the moment I put a number and ...

**0**

votes

**0**answers

14 views

### How can I create multiple charts based on a series filter using PivotChart?

I have a pivot table/chart displaying sales(value) by week(axis). I can add the branch to the legend and get one chart that displays the sales by week by branch.
The problem is that I have 100 ...

**0**

votes

**1**answer

30 views

**1**

vote

**4**answers

53 views

### How do I add 1 year to a specific date once that date has passed?

I have an excel spreadsheet that lists our current subscriptions. I have one column with the Date they signed up and then I have another column for the Renewal Date. Currently I have to manually ...

**0**

votes

**2**answers

50 views

### If cell contains “Specific Text” return value of cell beside it. Similar to VLOOKUP

I have 2 sheets, one with a list of parts(sku) and all the vehicles that the part will fit on (fitment) separated by "^^" it looks like this:
sku | fitment
1 |car1 ^^ car2 ^^ car3
2 |car2 ^^ car3
...

**0**

votes

**1**answer

20 views

### How do I insert rows in multiple excel tables simultaneously without vba?

I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible?
The tables are in different sheets if that matter.

**3**

votes

**1**answer

25 views

### Match based on String Length

I have data similar to:
My goal to to:
find the longest string in column A
retrieve the value in column B on the same row
so in the above example I want Juliet. If there is more than one cell ...

**4**

votes

**2**answers

340 views

### Generate Combinations in Excel

I have an input row which contains the cells:
30
30
30
50
50
60
100
I want to generate all possible combinations of length 3 from this set. So I would want rows containing 3 populated cells and ...

**0**

votes

**0**answers

31 views

### Word Mail Merge with Excel - Can't open both at the same time

I have a word mail merge for letters using an excel file as the data source. My problem is that I am not able to have both files open at the same time for editing (i.e. the excel source data and the ...

**0**

votes

**1**answer

16 views

### Excel Macro to draw xyscatter plot out VBA

I am trying to create a xy plot where the x values is the time axis (column A) and the y values are in the other columns. (in the example only C and D)
When I try my code from below, I get a graph ...

**-1**

votes

**2**answers

28 views

### how can i make my macro toggle a sheets visibility/hide?

i have the following code that i want to toggle a sheet being visible or being hidden:
Sub toggle()
If Sheets("Navigation (2)").Visible = True Then
ActiveWindow.SelectedSheets.Visible = False
...

**0**

votes

**2**answers

32 views

### Copying and renaming of .xlsm files using batch

Its glad to be here and i am really excited n new to batch scripting. I have been using a batch containing below for copying an excel from one folder to another
{
@echo off
cp -r ...

**2**

votes

**3**answers

24 views

### Excel SUMPRODUCT - exclude header cells from formula

I have two columns, one with a date and one with values, and I want to sum up all cells, where the year of the date is the desired year. My problem is, that I have headers in the table, and I don't ...

**0**

votes

**1**answer

17 views

### Excel Index Match - How to use iferror / indexmatch

I have a Cell like this
Postcode
2037
2009
2132
2042
2043
2048
2009
2010
Another Tab
2015
2048
2050
2006
2008
2010
2016
I want the result as - if the postcodes in another tab is in postcode - ...

**-1**

votes

**1**answer

22 views

### EXCEL: Can I get a count of a certain value from columns with certain headings, only from the columns with certain text?

A screenshot of the spreadsheet1
Hi
I am looking for a way (in the form of an Excel formula) that can do this
I need to count the number of "o" in columns with headings "Threat", for each row. For ...

**-1**

votes

**0**answers

40 views

### Excel Formula to show All dates in a range after today

I am trying to build a spreadsheet that I am using the lookup feature to take data entered on sheet 1 to locate that data on sheet 3, I need it to then list all Dates after today for the current ...

**1**

vote

**1**answer

34 views

### In Excel, is text zero or what?

I have a column of numbers that also contains the letter T. If I use a simple IF(A1>0,..., the letter T is treated as greater than zero and produces the "true" result. However, if I use ...

**0**

votes

**0**answers

10 views

### Auto-Fill data between two spreadsheets, adding new row, keeping same column, when new val

So I have a list of items that need to be constantly added to a list for auditing purposes. Problem is, the item names constantly change and also on occasion, new items are added.
Essentially, I am ...

**0**

votes

**2**answers

22 views

### how can I see what TYPE of data is in my macro?

I have the following code that doesn't work inside a macro:
count = Application.Sheets.count
ans = type(count)
msgbox("count is " & ans)
but this doesn't work cause I think type is looking for ...

**1**

vote

**1**answer

21 views

### Excel make a list with a specific conditions

I work in a hospital, have a list of patients, with name, date of admission, date of dismiss, and diagnosis. I need a list with all data when date of dismiss is blank, if contain something must skip ...

**0**

votes

**0**answers

19 views

### Excel autocomplete/ suggestion list. Not a drop down

I am using Excel to record various data and some rows have more cells than others.
How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a ...

**0**

votes

**1**answer

27 views

### VBA warning when cells selected are not equal to 5 and contiguous

My Vb macro does the following:
I select 5 contiguous cells, run my macro and I get 5 static random numbers between 1 and 50;
It works perfectly;
I need a warning when the selected cells are not ...

**0**

votes

**0**answers

12 views

### Excel save relative formula for re-use

I need to go through a sheet, filtering on a series of fields and running a formula against the resulting columns.
However, typing the formula each time is slow and annoying.
How can I save the ...

**0**

votes

**2**answers

11 views

### Excel filtering all cells in column instead of those filtered

I am trying to add column value in a sheet with a filter applied.
The problem I have is that Excel is adding values for rows that have been filtered out rather than just those the filter is showing.
...

**0**

votes

**0**answers

12 views

### Advance Filter with multiple criteria

I have three worksheets
ConditionSheet : Having conditions value in cell E5 & E7
SourceSheet : Complete Data
TargetSheet : When I run macro New worksheet create with this name based on ...

**0**

votes

**1**answer

43 views

### Extract multiple substrings from Excel cell

I have a horribly formatted column where each cell can contain zero or one or more entries like the following (this one contains two):
ACTI-U-9754 - Some description MDCF-U-9791 - Some other ...

**0**

votes

**1**answer

11 views

### Unable to remove columns based on data-type using Power Query

I am trying to automate a load process and want to know if it is possible to perform column wise operations in Excel Power Query. Specifically I want to know how to either keep or discard columns ...

**0**

votes

**1**answer

32 views

### How does this SUMPRODUCT(COUNTIF( )) function work?

I was searching for a solution to count distinct values in a range, and came across this article. The example provides a list of ten names comprised of four unique entries. It then uses the ...

**0**

votes

**1**answer

14 views

### Getting Excel to Auto Increment correctly

I have a question regarding Auto Incrementing when dragging formulas.
I have several series of data in columns on a sheet and I am trying to reference them on another sheet.
So on sheet2 I place the ...