excel 07

Hello there, I've trawled the internet and can't seem to get just the right answer for my query: I hope someone here can help. I have built a report with a front page, a calculations page, a clean data page and an export data page. The Clean Data page picks up what the user exports into the...

Thank you sir

I am trying to create an SLA (service level agreement) report. I have data that supports a date/time that something was requested and a date/time of completion all associated with 1 time zone. I need to be able to calculate the number of minutes between request to completion. Then take that...

I have two tables. A list of accounts and the other is a change log. I need to add a new column in table 1 where the value is the amount in table 2 for the correct account and correct validity period. Please help

If someone has a solution to this problem, I would be very grateful!! I'm no expert in VBA, so any help you can provide would be most helpful. I have my data in Excel 2007, protected by a password to open file, and read only password. I have a form in Word 2007. The user opens the Excel...

Hello Forum: I am just getting started with macros, could not make this work, and would greatly appreciate your help and expertise. The task we are trying to execute is essentially populating a chart (Sheet 1) repeatedly with data from sequential rows in a table (Sheet 2), and saving each...

hello, I would like to save individual worksheets. I have 6 worksheets. In 4 of them do if the CommandBox Save is clicked, the Save as window will open and the leaf should then be saved under the name of the field is in G10. urgently need this VBA code hopefully you can help me Jannik

It seems there is a problem copying from one excel applications worksheet to another excel applications worksheet through vba. I am opening two excel applications (not the same instance) and am trying to copy a single range of just values no formats and I keep getting errors. I have narrowed it...

I'm not an Excel poweruser and I may have bitten off more than I can chew, but here is my dilemma. I have filtered down raw data to only show providers that belong to multiple departments. There is a flag for each of these providers indicating Y/N in two different columns. I need to be able to...

Hello All, I have been trying to make the performance of my VBA code go faster as I am trying to complete a simple operation in a short period of time. I am trying to link one worksheet in a workbook to another worksheet in another workbook with only the data that I care about. So far...

Hi This is my first post, so I'm not sure how to upload an image of my example table, apologies if it makes no sense. I've been unable to find an answer to this (mainly because I'm not sure if I'm searching on the right term) I have a list of 20,000 products, some of which can be used as...

Dear Friends, Bellow is the format of text file, which I need to extract to excel sheet sorting on first ID Value 000080CC | IP:172.16.16.52 | 03-04-2013 09:16:54 000080CC | IP:172.16.16.52 | 03-04-2013 09:16:54 0000A5DD | IP:172.16.16.52 | 03-04-2013 09:16:54 0000A5D7 |...

Hi, I have a row of numbers that are number of kg's. However I need to split these numbers based on how many kg's were fed to different pens. For example the 1st row is the total mix size and the rows below will reference this row based on the proportion of feed i.e. total mix size 2,500kgs...

Status B & C: commission + 3% bonus ; Status A: commission only Status A is calculating correctly, but B & C is not. I'd appreciate any help with this. If StatusCode <> "A" Then Bonus = 0.03 Commission = CommissionRate * Bonus * SalesAmount Else Bonus = 1 Commission =...

Hi guys, I have a sheet with following data: <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> Item name Sheet Subject 1 1 Subject 2 2 Subject 3 3 Subject 4 4 Subject 5 1,2,3 Subject 6 1,4 Subject 7 4 Subject 8 1,3,4 Subject 9 2,3 Subject 10 3...

Hi All, I have trouble with excel sheet or the formula. I am trying to calculate Min with multiple conditions. The formula I am using is {=MIN(IF(Tier=3,IF(Location="USA",IF(LCount<>"",LCount))))}. If I use the formula on other sheets it works find but on this particular sheet it returns the...

Hi All, I am trying to figure out how to calculate max or min with multiple if conditions. Here is sample data: <colgroup><col><col><col><col><col></colgroup><tbody> Code Product Category Qty Min 1 1 Z 10 8 2 1 Z 9 3 1 Z 8 4 1 Z 5 2 D 1 6 2 D 2 </tbody> The condition is...

I have a large Excel 07 File based upon unique Print #s. Each print # may have one or more "details" line items (rows) associated with the print. Each print # also has several column fields. I need to create a "Master List" pulling from my Print # database. Ideally, I would click in the...

Hello I have written a UDF (Usder defined function), which accesses a access database and runs an SQL call in it and returns the data item. I'd like to automatically reference the "Microsoft ActiveX Data Objects Library" I use for this UDF and I have written a sub that does this Sub...

I've got an excel file with columns, C_IP SESSION_ID CS_USER_AGENT CS_URI_STEM CS_URI_QUERY WEB_LINK I'm not able to aggregate the above attributes due to the limitations of the string size allowed in Oracle (11g). I tried to use a user-defined aggregating function for this. I want to...