excel 07

  1. G

    Vlookup question - updating GL Account information shared from UNSPSC codes

    Problem: I have a spreadsheet that contains UNSPSC codes or commodity codes that are mapped to GL Accounts. I need to update the UNSPSC codes to the new GL accounts from an updated sheet provided from finance. 1) First thing I need to do is add the text "SHARE" as a prefix in front of the...
  2. A

    Match cells in column, then transpose matching row data from column b, c etc on many

    I have a spreadsheet with multiple tabs, and would like to transpose the data on each tab in the way described below: So if I have: 1 a 1 b 1 c 2 a 2 c 2 d I would like to get 1 a b c 2 a c d Same with multicolumn. if I have 1 a b c 1 d 2 e f g h 2 i j Would like to get 1 a b c d 2 e f g...
  3. B

    Copy row details Automatically a number of times as defined by a value in a cell

    I want to copy formula & formatting from say Row 3, Clm C to R to the next row a number of times designated by the value populated into a cell (say B1). ie if B1=4 i want to copy Row 3 (Clm C-R), to the next 4 rows, (Row4,5,6 & 7). Note i want the copy to happen automatically when the detail is...
  4. V

    Import data from multiple pages of a website into a single Excel sheet

    I am a cricket buff and like to see statistics. But they run to 47 pages running to 9,394 rows in a website. Copy and paste is not a solution. I look forward to your help in either developing an Excel VBA macro or any other way. Please see the first two pages here: Page 1...
  5. B

    How to create a Union query in EXL 2007

    Hello. I'm trying to create a pivot using multiple sheets in EXL 2007 but research has shown a union query would be the best way to do what I need. My data consists of around 4-6 sheets with two - four columns being used and rows can be in excess of 100, 000. A recent report I had showed 310...
  6. D

    If formula

    I have posted this previously but have not yet found the solution. If cell D6 has any of the following text entries; EUR / USD GBP / USD AUD / USD NZD / USD USD / CHF USD / CAD GBP / CHF GBP / CAD GBP / NZD GBP / AUD EUR / GBP EUR / CHF EUR / CAD EUR / NZD AUD / CHF AUD / CAD AUD / NZD CAD /...
  7. M

    How excel remember procedure which i make

    I in VBA Excel make some procedure and i want to use her alwause when i open excel with other document.Is there a way?
  8. SV18

    Selecting sheets via vba

    Hi all, I'm trying to select 3 sheets from a workbook and simply copy them to a new workbook, for some reason this is eluding me and I can't get the code right! Can someone please help, this is the code I have: Dim x As Object For Each x In Array("AC table", "Administrator table", "Scheme...
  9. J

    Counting down days

    I can’t get our inventories to project out correctly...I ran into a glitch on a 30 day limiter someone passed my way. It seems to trigger the conditional formatting regardless if the date has passed (i.e. it would show "green" for May 25 or May 15 because both dates are within the 30 days of...
  10. D

    Macro cell reference help please

    I have a spreadsheet with lots of data that is linked to other tabs in my spread sheet and I am looking for a way to copy a range of cells and then increase the reference in the pasted cells, so for example<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...
  11. R

    How to extract text of some color from single cell?

    I need to extract some text from singe cells wich has been marked with another color, let's say red. Do you have a simple vba macro subroutine which can extract the text and write it in another cell? I will apply this sobroutine in the entire database field. Sometimes the text is contiguos in...
  12. D

    Lookup text return average %

    Hi, I need to search cells L5:L35 for the text containing "YES" & return the value as a percentage over the number of cells in the range. Thanks so much for your help!
  13. D

    VBA: Copying Worksheets from Other Workbooks

    So every month I have to copy single worksheets out of multiple workbooks and considate them into a single workbook that I can then distribute. They are updated versions of the previous month. Each month they are in a new, but that folder is just copied from last month. (i.e march folder...
  14. T

    Access VBA to recognize Excel Creation Date

    How can I get my Access 2007 VBA to recognize this Excel 2007 value[ActiveWorkbook.BuiltinDocumentProperties.Item("Creation date").Value] ? based upon the time frame between date created (as seen in the Stats tab of Excel) and Last Saved, I need to import the file. I'm new to VBA but have been...
  15. L

    Dropboxes and VBA code in Excel 2007

    Hi folks, I need your help. I have the following situation. In a sheet2, I need to create drop-boxes (based on another Sheet1), one listing names of retailers, one some criteria (called "A"), one criteria "B", one "C", one "D". One is supposed to select one OR MORE names from each list (each...
  16. E

    Count how many cells are 10% or more greater

    Hello, I have Excel 2007 I have two columns of data: Booked Amount Actual Amount 10 11 100 95 20 14 50 64 100...
  17. M

    Excel auto formats numbers to currency

    I am having a problem where Excel 2007 randomly reformats dates and other numbers as currency. This also happens in pivot tables even though the source data is not currency. Has anyone experienced this before and know the solution?
  18. D

    Lookup

    Hi, I'm not sure if this formula is possible, but I will explain my situation. In cells G5:G24 are numerical figures that are both positive and negative. I need to lookup the range G5:G24 for positive figures and divide that number by the total number of cells & return that result as a...
  19. R

    Excel calculator form on web site

    I am a novice at building web sites but am trying to develop a work order form to be inserted on my website so customers can open a clear form, fill in the appropriate data, receive a price, save the document and email it back to me to place their order. So far I have created 2 workbooks and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top