Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

0
votes
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
2answers
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 ...