Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: monagan
  • Content: Threads
  • Order by date
  1. monagan

    Frontpage server problem

    Hey all, I am fairly new at website publishing I am making a webpage in frontpage for my company. They originally had a site done in dream weaver, and the person who made it is no longer around. I have been doing some research on this problem: server publishing to does not have front page...
  2. monagan

    Excel Vlookup Named Range

    If anyone can point me to a good thread that I haven't foudn yet, or give me some kind of direction on this problem. I have a parts table (excel) Parts Number Description weight 0123l5 something 5 235j7 something else 6 075dfg and...
  3. monagan

    CD ROM/ C Drive Copy

    A co-worker came to me with a question about there PC at home. They originally had the following: C: D: CD ROM Now they have this: C: D: Copy of C: E: CD ROM But the E: doesn't read the discs. He tried to format, but he needs the CD ROM to restore everything with the CD. Very starnge for...
  4. monagan

    Why Buy Crystal Report

    Hi, I am researching crystal reports for my company. I am looking for a report designer where I can add any field into a report, from any table. Right now, I'm looking to take fields from, ie, Inventory, and from Jobs, to make a table. I cannot do this in peachtree complete, will crystal do this...
  5. monagan

    Cannot Find data Path

    Here's a two part question. I have been having trouble with one user's peachtree software on the computer. I have installed, re-installed, and re-re-installed the peachtree 2005 software on a computer for a network, and it continues to forget where the data file is located. I get the error...
  6. monagan

    WORD: Undo Columns

    I hve a word document, and I put it into columns, using the columns button on the standard toolbar. But I only wanted it on some pages, not all, how do I remove the format on the pages I don't want it on? "We have enough youth, How about a fountain of SMART?
  7. monagan

    search and find value

    This was in a prvious post, but the subject did not do it justice. I have code that is supposed to find the row with a specified name in it, and find a specified date in a column and put a number at the intersection. Like so: 9/15 Bob 5 If it does not find the exact name or the 9/15...
  8. monagan

    EXCEL: Command Button Clicked on ENTER (RETURN)

    I need to know if it's possible to make a command button the default in excel, so that the enter key is hit, it will run the code as if the button was clicked. I have only on command button. "We have enough youth, How about a fountain of SMART?
  9. monagan

    if not there, add/insert

    I have sheet1 which a user enters in information. Name Date and WorksheetName In a different workbook, If it doesn't find Name I want it to add it after the last name in column A. If it doesn't find date, I want it to add it after the last date in row 2. And if it doesn't find the worksheet, I...
  10. monagan

    Intersection, Date, and Merged Cell Problem

    I have a worksheet set up with dates(merged cells) and departments(two separate cells) on the top and names on the side like this: 06/01-03 06/04-10 06/11-17 Ship Main Ship Main Ship Main Bob Jim Lisa Bill Now I have another sheet that someone puts in the date and the...
  11. monagan

    Checkbox basics

    I have 7 checkboxes What I need to do is if checkbox1(a15) is unchecked I want the values in c15:i15 to be 0. if it is checked, I want the values to be whatever the formulas in the cells come out to be. A quick suggestion or point to a thread I haven't looked at would probably be good...
  12. monagan

    No Macros!!

    If I go to run macros there are none I do not see any when I hit Alt+f11 So why does it say the file contains macros when started up?
  13. monagan

    Where's that thread?

    Hi all, I recently saw a thread on what to do when a workbook is already open. I believe it was something like, code opened a workbook, and they need the code to not open if the workbook was already opened. I cannot find that thread, I know it was on this site. I figured a lot of the experts...
  14. monagan

    Object variable not set

    I have this code that opens a another workbook and selects the worksheet. Sheet one has the Employee Name, The Date and The Worksheets to Open and the hours worked Sub openTimeSheet() Dim OpenSheet As String Dim wbTS As Workbook Dim lRow As Long Dim iCol As Integer Dim NAME As String NAME =...
  15. monagan

    Open Excel And work on worksheet

    I have searched and searched and could not find anything close to my problem. I have a command button, cmdsubmit When clicked I need it to open up another workbook named timesheets In this workbook it has worksheets named by the job number I have a1,a2,a3, a1- Name a2- Date a3-Job number...
  16. monagan

    Put Value at Intersection

    I have Name,Date,HoursWorked I need to know how to have excel look in another excel file and find where Name(column A) and date (row 3) intersect, and place the hours worked there
  17. monagan

    Date List

    I need a drop down list whether validation or combobox to take the current month and list all the days in the month and the last two days from last month. When the month changes, I need it to do the same thing with the new month. Any Ideas? Thank You in advance
  18. monagan

    Go back to the Top

    I have an exit excel command button at the bottom of a spreadsheet, and also saves. Here's the problem: Since I have to scroll down to click the button, and then it saves, the next time it is opened it starts at the bottom of the page. How Can I get it to scroll back up to the top of the page...
  19. monagan

    Easy ComboBox Question (Formula)

    I need to know how to use a combobox in a formula. I have combobox2 with cities I need to do =VLOOKUP(ComboBox1.value,MyTable,2,0) What do I need to use instead of ComboBox1.value because I get #name? error
  20. monagan

    Need an Idea

    Whether in VB or Not, I have been trying for days to figure this one out. I am not looking for an answer or solution, just a point in the right direction. I have 2 combo boxes, State, City And a data validation list,wind speed So here it goes... When the state is chosen, a list of cities come...

Part and Inventory Search

Back
Top