**0**

votes

**1**answer

16 views

### EXCEL won't link to Internet

I have downloaded data from a website that contains links to other website. When I click on any of the URLs in EXCEL I get the message :
"This operartion has been canceled due to restriction in ...

**0**

votes

**1**answer

7 views

### Hide number until date is entered

Column G has an "In Date" and Column H has an "Out Date". Column J has the "Average Days Between" Column G & H. Column K has the "Total Average" of Column J.
In Column K the formula is ...

**-1**

votes

**0**answers

19 views

### comparing 2 columns in excel and return the same result in a group

hi m new in excel function,
i have a problem like this. i have 2 lists of data
DATA I
NAME SCORE
----- -----
ANA 10
BUDI 20
TINA 30
DATA II
NAME SCORE
----- ...

**0**

votes

**0**answers

11 views

### Replace multiple words in Excel sheet

Sub xLator2()
Dim s1 As Worksheet, s2 As Worksheet
Dim N As Long, i As Long
Dim from(), too()
Set s1 = Sheets("Sheet1") ' contains the data
Set s2 = Sheets("Sheet2") ' contains the translation ...

**1**

vote

**1**answer

38 views

### Find and replace multiple words in a column in Excel 2007

Sub xLator2()
Dim s1 As Worksheet, s2 As Worksheet
Dim N As Long, i As Long
Dim from(), too()
Set s1 = Sheets("Sheet1") ' contains the data
Set s2 = Sheets("Sheet2") ' contains the translation ...

**0**

votes

**0**answers

13 views

### Convert COUNTIFS formula to SUM(IF) to enable external workbook references?

I need to convert the following formula to one that uses SUM(IF), as I am given a #value error when the external data source is closed.
...

**3**

votes

**2**answers

30 views

### Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?

We have lots of spreadsheets that have lists of numbered sound files for an educational app. We use spreadsheet features such as "fill down" for the numbering, and we often use formulas to check ...

**2**

votes

**1**answer

34 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

**1**answer

29 views

### How to I use SUMIF or SUMIFS to automatically add the values of different cells when they meet they meet multiple criteria

Basically I have a spreadsheet with three criteria columns.
I would like to be able to recognize duplicate HTS codes that also have the same country of origin and add the sum of those values, which ...

**1**

vote

**0**answers

26 views

### Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right.
I have a Workbook.Open routine which will change to custom formatting (and back on ...

**2**

votes

**0**answers

34 views

### copy data from multiple word files to excel with vba

I know this question was already asked (Copying data from multiple word docs into one excel sheet) the thing is I can't use the answer.
I'm fresh to vba, but I thought I can handle it. I was wrong. I ...

**0**

votes

**0**answers

23 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

20 views

### Copy the content of one cell, and insert within 2 characters, in the middle of a text content from another cell (Excel)

I am trying to batch copy the content of the cells in column A, and insert it within the "><" of the text in the column B. The result should look like the output in column C. Here is an example:
I ...

**0**

votes

**0**answers

25 views

### Return value from table using Multi-dependent drop-down list

I am trying to obtain the value of a column header (or topmost row value for a specific column) based on the selection of properties from 2 drop-down lists.
...

**0**

votes

**1**answer

18 views

### Hide sheets in shared excel workbook.

I have a shared workbook on which I have hidden some of the worksheets prior to saving.
I have closed the workbook. If another user opens the workbook the worksheets I had hidden are visible. If I ...

**-1**

votes

**1**answer

16 views

### Excel searching column and copying the cell next to it

i need to find the value from column C in the row B, and copy the value from found result in column D. If it's possible with formula and to copy formula to all cells in column D ? without VB?
Thanks ...

**0**

votes

**1**answer

16 views

### Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application.
Below is the example of code that I'm ...

**0**

votes

**1**answer

19 views

### How to match cell to column & return value based on that?

+-------+---+--------------+----+
| A | B | C | D |
+-------+---+--------------+----+
| Mark | | Hasan Shahed | 50 |
+-------+---+--------------+----+
| Hasan | | Saif Alam | ...

**3**

votes

**1**answer

100 views

### Excel 2010: Formula for Sum and Return Date

I have a workbook with a Summary sheet and a Data Set sheet with a linked table containing 700k+ records of financial data on investments. (In my particular case, it is real estate properties; but ...

**0**

votes

**0**answers

14 views

### How do I copy datas with blank/tab into multiple excel cells?

I got a data like:
xx5 600 200
xx6 500 100
I want to copy them into multiple excel cells, like:
--------------------------------------------------
| xx5 | 600 | ...

**0**

votes

**1**answer

42 views

### Pie Radar Chart outline series not working

I have been trying to create a Pie Radar Chart as described in answer to this question.
Everything works until I get to the section that describes inserting a series to create the chart's outline:
...

**-3**

votes

**1**answer

19 views

### need vba code to delete all the code after executing all the code

I need a vba code in Excel 2007 which will remove all the vba code after executing all the function. I am drawing an example here:
Option Explicit
Private Sub Workbook_Open()
'Runs a macro 10 seconds ...

**0**

votes

**1**answer

46 views

### Microsoft Excel 2007 - Drop down list that grabs multiple columns from another sheet

I've been scouring the internet for this but can't seem to find a solution.
Let's say I have 2 Sheets - "Items" and "Inventory".
Inside "Items", I have 3 columns:
Item Name
Item Type
Item Cost
...

**0**

votes

**0**answers

10 views

### How to find which cells in a column have numbers?

I have several name of products in Column A, like this
Biscuit
Chocolate
Hibis400
Cratey
Ubbret-131-small
Hingley
The data runs into hundreds and thousands. IS there a way to quickly identify which ...

**0**

votes

**1**answer

24 views

### Round Up Date - Require Complete Year

I have a sheet to calculate employees length of service.
Now with my current formula
=DATEDIF(D2,E2,"y") & " years, " & DATEDIF(D2,E2,"ym") & " months, " & DATEDIF(D2,E2,"md") ...

**0**

votes

**1**answer

30 views

### When try to open word/excel 2007, I am always getting Microsoft office enterprise 2007 configuration progress pop up. How to get rid of this

I have office 2007 and 2013 in my system. I uninstalled 2013. Now When I try to open word or excel 2007 files, I am always getting installer popup. How to get rid of this pop up once for all ...

**0**

votes

**0**answers

25 views

### How to search comma separated tags in Excel and get results in a column. [duplicate]

I'm trying to tag items in a spreadsheet, and search through them, in a similar way to Nusantara How to Label / Tag Items in a Spreadsheet
I've followed Excellll's brilliant advice and managed to get ...

**0**

votes

**1**answer

54 views

### Excel: find the cell that another formula found its “answer” in

I made a formula that searches an array to return a value, and now I want excel to "show its work" and tell me in which cell it found that value. I've been fighting with MATCH and ADDRESS but so far ...

**0**

votes

**0**answers

18 views

### Is it possible to convert one set of data related to static date ranges to date ranges that are dynamic?

I'm looking at converting P&L financial data from a company fiscal year to year post close of an acquisition assuming a dynamic post close date. I have 10 fiscal year columns, for example the ...

**0**

votes

**1**answer

45 views

### Excel Help: Search Column A, Sheet 1 for same value in Column A, Sheet 2, return value of Column B, same row in Sheet 2 [closed]

I'm surprised I couldn't find the answer on Google, maybe I am being silly.
I want to perform this function:-
I have two sheets in Excel, lets say they are Sheet 1 and Sheet 2
In Column A, Sheet 1 ...

**-2**

votes

**1**answer

22 views

### Use of conditional formating using formulas [closed]

In cell M100; I would like to color the cell GREEN if c100-f100+g100 = j100toj109. If they are not equal color cell RED

**0**

votes

**1**answer

21 views

### Excel 07 - declaring and sorting chunks of arbitrary size

Let's say I have a list of Abbreviations:
As you can see, the only layout "rule" is a blank line between entries.
I should now like to sort them by their abbreviation:
Using Excel07 and having ...

**0**

votes

**1**answer

39 views

### Excel formula for collapsing adjacent rows with a sum

I have a spreadsheet with values like so:
blah 1 12
2 12
3 12
foo 1 6
bar 1 2
foo 1 6
2 5
Numbers in the middle column range from 1 to 8; ...

**0**

votes

**0**answers

6 views

### Excel 2007 - Links on Network File Work, Then Don't

We have a spreadsheet in a networked folder containing links to other spreadsheets in that same folder. When first established the links are fine, SERVER/SHARED FOLDER/SUBFOLDER1/SUBFOLDER2/SOURCE ...

**0**

votes

**1**answer

54 views

### How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...

**0**

votes

**0**answers

32 views

### Creating automated Microsoft Excel filtered list

I have the following situation in one of my Excel sheets:
I have a table with some values, particularly "date", "stock" and "cost" among other data. The table may contain values from various ...

**0**

votes

**1**answer

47 views

### How can I sort data that is organized in 4-row chunks?

I have an Excel document with six columns and 57,000 total rows. Each record comprises four rows, that is, each set of four rows goes together. How can I sort this data by one field while keeping the ...

**0**

votes

**1**answer

62 views

### How to convert a string to a binary, then hex, value?

In one column I have a bitstring encoded as a string type. In a different column I wish to have the same bits (potentially starting with a leading 0), but as a binary value type. Ultimately, I want ...

**1**

vote

**1**answer

30 views

### Excel - Reuse a trend line to apply to other data

I've obtained a trend line from a particular set of data.
What I'd like to do now is to reuse this trend line to predict values from a given pair (x,y) of coordinates.
To put it another way, I have ...

**0**

votes

**0**answers

16 views

### How to Copy/Paste Link data conditionally (or achieve the same results), based on entries from one worksheet to the next within Excel 2007?

I am attempting to create a job log in Excel 2007 with two separate worksheets: Potential Opportunities (source sheet), and Interested Employers (destination sheet). These two sheets have the ...

**1**

vote

**1**answer

47 views

### Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Let say I have an excel sheet with structure like
I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):
And click Ctrl+V. It gives me ...

**0**

votes

**2**answers

43 views

### How to dynamically populate a filter list with “first match” on a row, using excel 2007

The image is an example of what I am working with. I am trying to write a formula in my leftmost column, just under the listbox cell that you can see, which will find a string/value match in that ...

**1**

vote

**0**answers

9 views

### Embed an dotm file into an Excel document

I have a dotm file( macro enabled word template). I want to insert it into an Excel file and I want to open it by the clicking of a command button in Excel form. The problem is, when I open this dotm ...

**3**

votes

**1**answer

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

**0**

votes

**1**answer

48 views

### Excel - Sum certain range from pivot table

I have an excel pivot table that looks like the following:
Is there any way I can create a formula that will calculate the sales$ for a particular product at a particular store for a particular ...

**1**

vote

**1**answer

65 views

### Sorting Dates in Excel By Month

My boss has given me a job in which he has given me the names of customers and their wives who has bought our products from 2 to 3 regional offices. My boss wants me to format all this data into one ...

**0**

votes

**0**answers

28 views

### Cannot “save as” file on Microsoft Excel and Word 2007 running on Vista Home Premium edition

I have Excel and Word 2007 running on Vista home premium edition. After working on a new file and try to "save as" just before naming the file, a window pops up 2 dialog messages "Search online to ...

**0**

votes

**2**answers

51 views

### How to automatically update values referenced from one sheet to another in excel

Here is my problem . I have 2 to 3 worksheets and I need to make a master worksheet . The 2 3 worksheets are containing the sales made in the day and the customer name . the problem is that new ...

**2**

votes

**1**answer

55 views

### How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?

**0**

votes

**2**answers

48 views

### Is there one simple formula for Excel that can identify a string contain non-ASCII Characters?

I know that using the clean formula, I can clean up some of the non-ASCII characters (such as additional non-printable ASCII control characters #0 through to #31, #129, #141, #143, #144, and #157 ...