excel 07

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

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

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

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

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

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

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?

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

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

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

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

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!

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

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

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

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

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?

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

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