Search results for query: *

I'm trying to create a list based on the value in a column of another table. I can't use pivot tables. So the data look like this: ID# Status 1A Open 2A Escalated 3B Closed 4R Escalated 5E Open etc. From this table I want to create a list that just contains the...

Hi - It seems that all of the vba code in an excel workbook is not being called when the events occur in the spreadsheet. It's almost like the code has been deactivated (it was working fine before) I've played around with all of the security settings but still seem lost at figuring out why...

Hi - It seems that all of the vba code in a workbook is not being called when the events occur in the spreadsheet. It's almost like the code has been deactivated (it was working fine before) I've played around with all of the security settings but still seem lost at figuring out why this is...

Hopefully this is an easy one but I'm stumped. I have a pivot table and instead of grouping the headings, I want every cell to show it's value. Note that I've hidden all of the sub-totals. So, instead of X AA 1 BB 1 CC 1 Y AA 1 CC 1 Grand Total 5 I...

Hi, I'm looking to autonumber in Column A based on criteria in Column B. In other words, once someonse selects "Open" in Column B, I want the Column A cell to add the next unique number in the range of Column A. I want to use VBA since I want this value to be static. Here's what I have and...

Hi, I'm looking to autonumber in Column A based on criteria in Column B. In other words, once someonse selects "Open" in Column B, I want the Column A cell to add the next unique number in the range of Column A. I want to use VBA since I want this value to be static. Here's what I have and...

I am need to put a static date stamp in Column S based on data changed in Column B. I am using code that has been suggested and it is working on providing the date stamp, however I'd like to take it a step further and only have the date stamped in Column S when Column B is specifically...

Hello, I am attempting to import an excel spreadsheet into Access. The spreadsheet has a lot of text in some of the cells which have been formatted with carriage returns (bullets, numbering, etc.) Is there a way to import the formatting of the cells into Access or do I have to remove all of...

Hi, I am creating a button that needs to open another form. Going through the wizard, I am only able to set the criteria for one field to match, except I want to use 2 fields to designate the filter that needs to be placed on the opening of the new form. I know that I need to do something to...

Hi, Here's what I want to do. I have a Test Case ID that is comprised of Business Process and a # (ie. Order Entry-1) In my test case table, the combination of these fields serves as the primary key. Right now I have a form where the user can enter new Test Cases. The form is set up so the...

Hello, I have 3 tables: 1. Requirements 2. Test Cases 3. Reqs Linked to Test Cases I need to have table #3 as the table maintain the many to many relationship (in other words test cases can have multiple requirements and vice versa) So here's my issue: I have a form in which I want to...

Hello, I am attempting to create some vba code that will copy a range of rows into another worksheet. Here are the details: 1. I want to copy all of the rows that have data in the "Defect Macro" worksheet. This is the range B10:C? (?-because I don't know how many rows) 2. Paste this...

Hello, I am trying to add a text box that I want to link to an excel file. I am using Acrobat 5.0 to edit the PDF. I create the text box and then use the link tool to create a linked invisible box around the text box. Everything seems to work fine in Acrobat, but when I try to open the PDF...

Hello, Is there a way that I can create a macro in excel that will open and run a predefined macro in MS Project and then close out of MS project? Thanks, Tom

Is there a way to call and run a MS Project macro from MS Excel? I have several macros in Excel and 1 in Project that I want to run in a certain sequential order. Is it possible to call and run the MS Project macro from Excel? Thanks for you help, Tom

Hello, Currently I am using a macro to grab an external bitmap file, resize it and paste it as a picture in excel. How do I set the picture to a specfic name in the macro? In other words, instead of pasting in picture and letting excel automatically name the picture "Picture 8", how would I...

Hello, I am trying to create a macro in Excel that will copy a graph on the current worksheet and paste it in a particular area on another worksheet (all within the same workbook). I receive the following VB error: Run-time error '1004': Unable to get the ChartObjects property of the...

Hello, I'm creating a new spreadsheet and I'm ending up with about 10 or so tabs (i.e. worksheets). At the bottom of the page where all of the tabs reside, is it possible to have two rows of tabs shown? (Tabs 1-5 and then layered underneath that tabs 6-10?) I do not want to have to have the...

Hello, I'm having an issue with an old PC. It has Windows 98 and I have been connecting to the internet by modem dial-up using Earthlink and AOL. However, all of the sudden I have a problem that has me stumped. When I try to connect to the internet using either of the ISPs, the modem places...

Hello, Let's say I have an excel worksheet with a column called "ID". As people enter IDs, I want the cell to perform data validation on the column (all of the cells above and below the current cell) to make sure that each ID entry is unique. I also need to be able to add rows to...