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
0answers
24 views

Excel Icons for matching cell size

The old Excel had two icons - one for columns and one for rows. Clicking one of these would automatically match the size of all the columns and go all the way across or down the page. I am now using ...
0
votes
2answers
40 views

Excel Indirect #ref error [closed]

Trying to use the INDIRECT formula to pull a summary at the end of a large workbook. I have listed the Worksheet names in a single tab and now wish to use these to pull specific cell data into a ...
1
vote
0answers
24 views

Control Number Generation

So currently I have the following. When I click a button or hit submit button The form looks on the Ledger Tab. I was trying to get the form to automatically generate a control number (ConNum) that ...
0
votes
0answers
16 views

Referencing in Excel

I have 2 excel spreadsheets and I need to reference data from 1 sheet to another. That is simple enough but this is where it gets complicated. Sheet 1 is my reference sheet and sheet 2 is my formula ...
0
votes
2answers
159 views

How can I select and output the first and last row of a worksheet or a filtered list?

I am new to VBA and I have no clue where to start with this. I have two columns of data: Team Member Time A 1 A 2 A 3 A 4 I am only interested in ...
0
votes
0answers
243 views

Install older version of MS Office without removing newer version first

I'm currently running Microsoft Office 2010, but I temporarily need Excel 2007. I know I can use the Custom setup at the 2007 install process to select just Excel, and based on the Setup Help page: ...
-2
votes
1answer
58 views

Need to scrape data from notepad and convert to excel. Need any software or excel formulas

TEXT FORMAT Below: October 9, 2013 Williams J G ODROMA55@HOTMAIL. COM Julie M Riveness 64 Massey PI SW Prince Rupert BC 4032533446 6414674117 Evening Z496277 ...
0
votes
1answer
50 views

Need VBA Code to Combine Rows if rows A-F are the same

I need a VBA code that will combine rows if, for instance, Rows 4 & 5 have the same values in columns A:F. However, then I need for Column G to be split. G4 stays as G4 but then G5 becomes H5. ...
3
votes
1answer
162 views

How to remove a macro button added by customized ribbon in home tab?

I have added a macro button in an excel sheet by customize ribbon and have assigned some VBA code to it to do some particular task. The problem is that when I open any new workbook, Excel shows that ...
0
votes
1answer
81 views

How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted. I am using conditional formatting's "use a formula ...
0
votes
2answers
83 views

If multiple cells are with the same text, return this text(value) to another cell

I need your help with this: If A1:E1 is "Red", return "Red" to C3; If A1:E1 is "Blue", return "Blue" to C3; BUT If A1:E1 are not the same, return False or "X" to C3 What function to use ...
3
votes
1answer
732 views

Excel Large Function with Duplicates

I'm trying to apply a LARGE function to get the 5 largest values from a column ignoring duplicates. I did some searching around and found some proposed solutions but they don't seem to work for me. In ...
3
votes
1answer
68 views

Autofit row height in Excel 2007

Using Excel 2007. Attempting to insert photo in each row and a specific column, but when the picture is inserted the row doesn't adjust to the height of the photo. I've tried selecting the row and ...
0
votes
2answers
111 views

Excel: check if two cells have specific content and show true/false in another

I have a large datasheet with multiple columns. Long story short, my columns A and B (of text type) are lists of codes. For simplicity's sake let's say column A is days of the week, while column B is ...
0
votes
1answer
103 views

Excel Convert Row into Multiple Columns

I have a very long list of data that looks like this: User1 Item1 Item2 Item3 User2 Item1 Item2 #NUM! (This is a failed formula) User3 Item1 #NUM! #NUM! And I want to ...
1
vote
2answers
190 views

Excel: using 2 cells to collect data from a list

My Example is this: (workbook name"Rev) letter weekly bi-weekly monthly a 100 200 400 b 110 250 500 c 111 300 600 d 112 350 700 e ...
0
votes
0answers
28 views

Matching words from two title and calculate %

I was trying to automate an Excel file which has title in both A and B columns and I have to search each word from A within B and calculate the % by using the "no of words matched/total no of words ...
61
votes
2answers
3k views

Excel - can I set a cell to equal a certain value, no matter what is typed in it?

This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell ...
1
vote
1answer
61 views

Excel 07: Sum Cells of Column B By Date in Column A And Report To Cell C

So basically I have a worksheet like so, The data is manually entered in, column A is the date, the values are column E. Everything else is arbitrary and filled with x's. Basically what I want to ...
0
votes
1answer
65 views

How can I convert colums to rows in Excel? [duplicate]

Below is a sample of a spreadsheet I have (fig 1). It has been exported from an asset tracking system and provides me a list of information about the hardware we have. Each asset "area" uses the same ...
0
votes
1answer
38 views

IF X and A display area “A1,G20” If X and B display area “A1,G20” but on a different sheet

I'm trying to put together a excel spread sheet for our quarries. but we have a lot of different pits along two rivers that we collect our raw material from each with its own set of sieve results. now ...
0
votes
1answer
186 views

How to modify these VBA codes to save excel sheet in excel format (.xlsx)?

I have added a button in excel sheet and now when I click that button it saves the sheet at specific path with specific name but in pdf format. I want to save this sheet simply in excel format ...
-2
votes
1answer
55 views

How do I add a button to a spreadsheet and remove borders from a particular cell?

I have two queries regarding the following Excel file: I would like a button on this excel sheet whose name should be “Save as PDF”. When I press this button it should save the excel sheet’s ...
2
votes
0answers
31 views

Excel 2007 on Win 7 Home Edition — failure to sum numbers when pasted from other source

I copied/pasted columns of numbers from my bank statements into Excel. When I try to sum groups of numbers, it does not sum them. Matter of fact, when I select a group of cells with numbers, it does ...
1
vote
1answer
150 views

Highlight Cells with Red Text

I have a column of text in which some characters (not cells) are in red font. Is there any way to highlight the cells which contain red characters via conditional formatting? VBA solutions would be ...
0
votes
0answers
56 views

Conditional formulas in Microsoft Excel

I have different conditions in a sheet where I need to update certain factors like term of loans and down payments. How do I apply a formula in excel where I can get direct result for these: Down ...
1
vote
1answer
53 views

Excel - group cells that the values together is near to a number

I have this spreadsheet: Street 1 | 234m street 2 | 438m Street 3 | 759m Street 4 | 934m Street 6 | 126m Street 7 | 462m These values are summed and divided by 2 in this example, because let's say ...
0
votes
2answers
47 views

Segregating title into words and searching it in a another title

I was trying to automate an Excel file which has title in both A and B columns and I have to search each word from A within B. If any words matches then I need to paste it after B column which is ...
0
votes
0answers
13 views

Excel spreadsheet calculation does not happen

Excel spreadsheet calculates fine when entering a value, but then to change that value back, the calculate option appears in bottom line. Why?
0
votes
2answers
48 views

How to compare time in multiple rows using excel 2007

I need help to compare time in multiple rows in excel. I am creating a new rule in conditional formatting. I'm entering this formula in formula bar to compare time across multiple rows: =IF($E$4:$E$6 ...
1
vote
1answer
62 views

Copy Conditional Formatting 3-Color Scheme to another tab

I have one sheet, Tab 1, with a 38x12 grid of values ranging from -30 to +30. I applied the traditional 3-color scheme conditional formatting to the data, which shows all shades of the spectrum ...
1
vote
2answers
94 views

Extract string containing a word from an Excel cell with hundred of strings

I have an Excel workbook, in column A each cell contains all URLs of a site (this means hundreds of URLs in one cell). Among all the URLs within a single cell I want to extract only the URL that ...
0
votes
0answers
73 views

Realtime update of Powerpoint data from excel (no graph)

I am trying to create a PowerPoint to be used for a non-profit gala pledge drive. I want to show the names of folks pledging and the amount. Plus, the running total of amount pledged. I was planning ...
2
votes
1answer
71 views

On Excel I want to create a list from another sheet based on two values

I have 2 values in dropdown menus in cells B2(DATE) and B5(ITEM). from these values I want to create a list of items(based on B5) that were sold on that date(B2). The transactions are listed on a ...
0
votes
0answers
9 views

Excel is removing embedded images within by 2007 files. How to I prevent this?

I have embedded Jpg images into a column within an excel 2007 worksheet. However when I try to reopen the file, excel says it can not read the data in this Column and then strips it out. How do I ...
1
vote
2answers
111 views

How do I create randomized word lists that are dependent on a master list?

I am using excel for Mac 2011 For a linguistics project I want to do the following. I will have a word-list like this (in reality it will be much bigger): Master List: Bag Leg Magnet Apple Gum ...
0
votes
0answers
11 views

MS Excel 2007 report made using Excel is slowing down day by day

I have an Excel file on a shared folder in use daily, perhaps 5-10 times per day. Editing it less than 5 times a day. My assistant doing same. The size of that file (empty) is less than 600 KB. Also ...
0
votes
1answer
35 views

Taking data from an adjacent cell by name in cell

I am a basic Excel user. I do a monthly rota which has the staff name in one cell and in the following cell it has the hours worked. Is there a simple way to write an formula so that Excel takes any ...
0
votes
1answer
88 views

VBA Script loops in all sheets but doesn't produce output in all sheets

This VBA script I have loops through all sheets but I don't see the output in all sheets. What would be the reason be? Sub A() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets Dim ct As ...
0
votes
1answer
64 views

How can I apply this macro to all the pages in an excel file

I have a code to do a particular modification to some cells in a page. I'd like to apply this code at one click to all the pages in the excel file. I'm using VBA and am a newbie to it. Here's my code ...
2
votes
1answer
78 views

How can I execute this function using VBA in excel?

I'm trying to get this function in VBA but I'm new to it. I don't seem to know how I can get this done: What I'm trying to do is, for each cell in column B that's numeric, I want to take the next ...
0
votes
1answer
16 views

How to fill missing times with dummy values?

I have quite an urgent question. I have data (concentration) which was logged every minute. However, when I download my data there are some times (e.g. 1 or 2 minutes) in between missing. For 24h I ...
0
votes
1answer
127 views

How to copy a formula or value into another formula

I want to know how to copy a formula into another, while keeping the original values. For instance, I have in range A1:A5 five values (a mix of constants and/or formulas) and I need (in that same ...
-1
votes
1answer
72 views

How to expand a range of values to individual values separated by commas in MS Excel 2007 and 2010

How to expand a range of values to individual values separated by commas? Example 1: convert R1-R8 TO R1, R2, R3, R4, R5, R6, R7, R8 1-10 TO 1, 2, 4, 5, 6, 7, 8, 9, 10 I need these expanded range ...
0
votes
2answers
191 views

Reset Sequence Number With Change of Month

(Cell A1) Invoice Reference No. EPS-I-S151001 (Cell B1) Invoice Date 05/Oct/15 Once the Invoice Date is manually entered, Invoice Reference No will be automatically generated. The ...
0
votes
0answers
53 views

Can Excel auto generate squencial number?

I have a manual invoice registry log which I would like to overhaul. Currently I will manual assign an invoice number when I want to create a new invoice. Let's say Column A is the Invoice Number and ...
1
vote
0answers
28 views

Excel gives error while opening file recovered from a corrupted drive [duplicate]

I accidentally deleted my data on my drive which also got corrupted when I tried to recover the data. I got my Excel files back but they are not opening. Excel is giving errors that it is damaged or ...
0
votes
0answers
42 views

Populate information from on spreadsheet to another on same excel File

I am creating two sheets for one excel file for business conferences . One sheet will be an inventory list of items being sent to conferences, the other a sheet that contains details of the ...
1
vote
1answer
71 views

Performance Gain From Excel 2007 to 2010/2013 for modern PC

My work recently upgraded my department’s computers to shiny new spiffy i7 ssd 16GB RAM boxes. I spend most of my time in excel/access and the company still uses the 2007 versions of this software. ...
0
votes
1answer
52 views

How do I get the cells with no dates to have no color until the date is entered? All of the unused cells are red

=DATEDIF(F2,TODAY(),"m")<=47 THE CELL TURNS NO COLOR =DATEDIF(F2,TODAY(),"m")>57 THE CELL TURNS RED =DATEDIF(F2,TODAY(),"m")>54 THE CELL TURNS PINK WITH RED WRITING ...