Search results for query: *

REPOST- Put the original message in wrong forum by mistake. 8( I'm looking to put a formula together in one cell versus many. I've tried using the "If" statement but its to messy. I have an example of the table below. What I want to do is in cell A3 have a formula that looks to the right (Col...

I've developed a spreadsheet comparing travel times. I have the time from point A to point B listed in one column. I have time from a different point A, to the same point B listed in another column. The time is formatted as h:mm for each of the cells. At the bottom of each of the two columns I...

Good Afternoon, I posted this under the VBA site earlier this morning and no response so I thought perhaps it belongs under the Sharepoint section instead and I've reposted here. I built an Excel app using VBA and a series of Userforms that I migrated up to a Sharepoint site. The file runs...

Good Morning, I built an Excel app using VBA and a series of Userforms that I migrated up to a Sharepoint site. The file runs fine on my local machine but gives me an error message when run from Sharepoint. DETAILS: I hide the application in the background when the workbook is opened...

I have another Userform question. I have coding so that scroll bars appear and work fine on the right side of my form so that my users can scroll up and down by clicking and dragging the bar up and down. How can I make my form scoll as my users tab from one textbox to the next? Or if the user...

I'm missing something. I have a userform with a series of textboxes for my end users to input information. I then have the "Save As" dialog box to save the workbook open when the user has completed the form. My "expectation" is that the data entered into the text boxes will remain there when the...

Good Morning, I have a userform with multiple textboxes and a "Submit" command button below. I want the user to add values, text to the textboxes and have the data post to a master sheet when they're done. I know how to do this with one textbox at a time however I'm trying to streamline the...

Good Morning, I have a user form with several command buttons on the bottom and two option buttons. When my user clicks a button I am checking to make sure that they've made at least one selection in the option buttons before continuing on with the program. I wrote the sub below and inserted...

Good Morning, I have a pop up calendar that appears when an image is clicked on the user form. Private Sub Image1_Click() frmCalendar.Show End Sub and this is working correctly. I want the date that the user selects to be transferred to a text box control that I have next to the calendar...

I have a Workbook with 5 spreadsheets listing items that can be ordered by the departments in my office. The total number of items are multiplied by their cost and that figure is linked to an invoice sheet. Here's my issue: on the invoice sheet Cells H6, H16 and H26 have a sum formula. If the...

I receive an excel sheet of data from another application. This sheet is saved in a folder. I have VBA written to copy and paste the sheet into another workbook. All of that works fine. Here's the issue: Column A of the imported sheet has zipcodes that have a leading space before the number. I...

I'm trying to copy a range from one sheet and PasteSpecial to another located in the same workbook but I can't seem to get the PasteSpecial to work. I'm getting error messages. Here's my code: it's quite simple.(My actual code does not wrap as it does here in my post) Sub CopyRng() Set rng1 =...

I know about the use of the F4 shortcut key to convert a formula from relative to absolute after inputting in a cell. However is there a quick way to highlight a column or row and convert all of the formula's to absolutes at once?

From Columns A2 to H2 I have column headings to which I applied an autofilter. In cell F3 & G3 I have the formula =SUBTOTAL(9,F4:F991) & =SUBTOTAL(9,G4:G991).So when I change the filtered item in A2 I get the corresponding sums in F3 and G3 each time and that's working fine. Here's my issue...

In Excel 2003 I have my data sorted so that it groups by row in column A. For instance A1= Smith, A2 = Smith, A3=Smith and then A4= Jones,A5 =Jones, etc etc. I want to shade the rows based on the grouping in the A column. In an empty column to the right in Column P i put a formula in that reads...

I constructed a pivot table of the data on sheet 3 in the workbook and then renamed the pivot table worksheet "Rollup". What I'm trying to do is have the pivot table located on "Rollup" refresh automatically if/when I edit sheet 3 where the original information is stored. But the code I'm...

I have a spreadsheet that is designed to determine monthly cost savings which roll into an annualized amount. Column F has a date that the end user puts in for when the savings is "expected" to begin. The potential date range used is the fiscal year which is Oct 1, 2008 and ends Sept 31, 2009...

In excel 2003 I have a dataset of several hundred rows and 20 columns that is sorted on one of the columns in descending order. I have a combo box that allows me to make a selection and the dataset is then autofiltered based upon the listitem chosen in the combo box. This all works fine but...

I'm running VBA code in EXCEL that will follow a hyperlink on a spreadsheet and I'm getting a warning message, "Opening http://flash/subscriptions/RQ_49460.csv (not the real address because I didn't want to post actual address on internet) Some files can contain viruses or otherwise be harmful...

Is there a way to setup a macro to click a hyperlink in an email message?