excel 07

Hi! I'm stuck on this one and have been trying to figure it out all day, with no luck. I'm pretty new to VBA and macros so what is easy to a lot is quite the challenge for me. I have a workbook that I need to put some code into that will go to a specific sheet then open up a SharePoint document...

i have 2 sheets. First sheet contains 3 columns(A,B,C) and second sheet contains 4 columns A,B,C,D, Column A is common in both the sheets. Please refer the foolowing exaxmple Sheet1 Sheet2 A B C A B C D 1 PL O 1 K 3.5 8 1 LC U 1...

Hi All :) I'm trying to do a Vlookup on a file that gets automatically downloaded to the computer from a website. The data is in lots of different data sets, like so: Loans to countries Mar Apr May Jun Loans to banks Mar Apr May Jun Every month a new row of data gets added to each table...

Good morning, I have an excel form in which I would like to upload on the web for other people's access. This is an order form wherein they will place the order and with a click of a button, the order will be sent to an e-mail of my choice. Is there a way that I can do it? How? Thank you for...

Hi All, Firstly, I apologise if this query has already been raised. I did look to see if there was a problem similar to the one I'm experiencing, but I wasn't able to find one. Ok, here goes. I am trying to highlight cell relating to quantity of available stock. The cells contents have...

My chart axis includes dates from 8/1/12 to current, right to left. My data is chartiing for all dates, but it is not aligned with the dates on the axis; i.e. my data for 8/1 is aligned to the 8/22 date. I have checked and rechecked all the data references, and all seem to be ok. Any ideas?

I have a spreadsheet that is attached to a database. The first sheet has the data that is to be copied into a second spreadsheet. The values in columns C through I have to be copied and repeated in the second spreadsheet repeatedly. The data in these columns are to be used to store the data into...

The Problem: Revenues are received monthly and then distributed to two different parties at percentages that change. 1. At first, 75% of the revenues will go to Mark and 25% to Frank. 2. This arrangement of 75/25 will be changed to 25% to the Mark and 75% to Frank once Mark’s initial investment...

Revenues are received monthly and then distributed to Mark and Frank. At first, 75% of the revenues will go to Mark and 25% to Frank. This arrangement of 75/25 will be changed to 25% to the Mark and 75% to Frank once Mark’s $1000 investment is paid back. Once both parties have been compensated...

Hi, I have the following set of Excel data that I would like to get on same graph. For the sold items, I would like to use the Date as the horizontal axis. For the milestone, I would also like to use the Date as the horizontal axis, but I want to get the label (G0, G1, G2) displayed on the...

Dear Potential Helper, I am in the process of creating a database, and have used 'Data Validation' to create drop down lists in order to obtain information quickly from the database. I have encountered an issue where if I have a list the resembles the one shown below, the drop down list will...

Hi, Using Excel 2007 I have been linking two databases, both containing latitude and longitude values. Through a formula I calculated the distance in miles for each entry in database 1 to each entry in database 2 using names. The new sheet contains almost 19000 rows and 500+ lines. Thus the...

I wish to create a macro that looks in a specific directory "D:Records" It finds the files which are modified after a date "January 01, 2012" in this directory (pdf files) Then it imports these files names into a worksheet Is this possible please??? Please Help...

Pivot Table Help: Microsoft Office 2007 - Hi! I need to filter values from a calculated field. The calculated field is a %, and I need to filter so I only view values greater than or equal to a certain % (65% in this instance). I am viewing 6 months of data, and the filter is using the 6...

If I have a list of years (some occurring many times) how do I make a list in the next column to add any years that don't appear. For example: My list looks like this: <colgroup><col span="8" width="51"></colgroup><tbody> 2000 2001 2001 2002 2004 2004 2004 2006...

Hello all, I need to save an Excel worksheet to PDF and retain it's paper size of 11 x 17 landscape. Below is the macro I currently have and it runs but saves the pdf in 11 x 8.5. Any help is greatly appreciated. Sub CreatePDF() 'Creates an individual workbook for each worksheet in the active...

Hi, I was wondering if anyone has a way of selecting all sheets and saving all of them as a PDF using VBA? Or is there just a way to save the entire workbook as a PDF using VBA? Cheers, E

I have a macro which pastes the username and time stamp, every time a certain macro is used onto a worksheet. If sumitted multiple times, i have another column which identifies that the data has been previously submitted. I am interested in highlighting the row or somehow make the last...

Consider the following (partial) Excel worksheet: A | B | C | D ---+-------------+-------+------- id | date | var_a | var_b 1 | 2011-03-12 | 200 | 34.22 1 | 2011-03-13 | 203 | 35.13 1 | 2011-03-14 | 205 | 34.14 1 | 2011-03-15 |...

Hi I am looking formula which will determine the value of a certain cell and apply the same value to other cells simultaneously.. For Eg:- If J33 is '0', then K33, M33, N33, O33, P33, Q33 & R33 should be '0' as well without I filling it I have attached an image file for your reference. Thank...