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 Chriss Miller 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: camster39
  • Content: Threads
  • Order by date
  1. camster39

    GoDaddy email Spam

    On my GoDaddy email account, I have automatic forwarding to my icloud email address. Over the past 3 weeks, I have been inundated with Spam. I do notice; however, that 95% of all my Spam does NOT get forwarded to my icloud email address which is good. All other, non-spam, email is successfully...
  2. camster39

    USB Splitter / HUB?

    From my MFC-Brother printer I have a single USB cable that is running directly from the printer to my PC. It works fine. I want to keep this existing line running to my PC but I also want to split this and also run another line to a USB port on my Netgear Wireless Router. This way I will have...
  3. camster39

    Burn DVD from various file formats

    I am using OJOsoft to create any of the following video files: MP4 AVI MPEG MOV VOB etc..... Once I have the actual file created, do I need DVD burning software to create an actual DVD? I was under the impression that a VOB file can be read by any DVD player, therefore, I just copied my VOB...
  4. camster39

    Excel formula needed - cell reference

    I have a spreadsheet where each row corresponds to a specific month, by year, and there are 3 rows separating each year. The first month starts in Row 4. Example: Row 4 = January 2008 Row 5 = February 2008 Row 6 = March 2008 Row 7 = April 2008 Row 8 = May 2008 Row 9 = June 2008 Row 10 = July...
  5. camster39

    Cell Reference in Excel

    In Worksheet A I have a monetary value in Cell A13 - I am trying to derive a value in Cell A40 that references Worksheet B for the resulting value based on Cell A13: ________________________________________________________ Worksheet B looks like this. Column A Column B $1,300 $400 $1,310 $410...
  6. camster39

    Excel - reference 1 worksheet & populate another worksheet

    I have 2 worksheets, 'Final list' and 'NJ List'. There are 3 columns in 'Final List' that are not yet populated with data. They are 'email', 'phone' and 'title'. I want to reference NJ List and if there is a match for first and last name (which are contained in both lists in columns A & B...
  7. camster39

    Word Merge - Formatting Fields

    I have a simple excel data source that contains currency amounts: 1 - Renewal Amount 2007 (example $25,000) 2 - Renewal Amount 2008 (example $32,000) When I merge into MSword it appears as 25000 & 32000 respectively. How can I format in Word so that it appears as currency? I seem to remember...
  8. camster39

    MS Word mail merge .....

    My word template has the following fields: Company Name Activity 1 Activity 1 Date Activity 2 Activity 2 Date Activity 3 Activity 3 Date My data source (a CSV file), however contains multiple records for each activity for example...... ABCM Corp, Call Client, 1-12-08 ABCM Corp, Set...
  9. camster39

    Seperate Rows

    Column A - Employee SSN Column B - Employee First Name Column C - Employee Last Name Column D - Benefit Plan Type If the value in Column D is anything other than "Employee" then there will be a value in columns E,F & G, otherwise there will be no values in E,F & G. Column E - Dependent First...
  10. camster39

    Outlook 2003 - opening MSG files

    My old PC was running Outlook 2000 --- I have a bunch of emails that I've saved to my hard drive on the old PC. To save I would just open up the email in OL and choose File - Save As - Message Format(*.msg). I copied over all of the .msg files from my old machine to the new PC which is running...
  11. camster39

    New XP Install - missing drivers??

    I just did a fresh install of Win XP on my Dell Dimension 8300 after a defective hard drive was discovered. I removed the defective drive and kept the good one (it was a Raid 0 setup with 2 drives). I ran through the XP setup without a problem --- after the install however, I am not able to...
  12. camster39

    Excel Formula

    Column A contains Soc Sec No Column B is Employee Last Name Column C is Employee Middle Name Column D is Employee First Name Column E is dependent Last Name Column F is dependent First Name Sorted the spreadsheet by column A – if an employee has more than 1 dependent there is a repeat of the...
  13. camster39

    Matching Cell Values?

    In Column A I have a master list of all Social Security Numbers. In column B I have a partial list of Social Security Numbers. I would like to create a formula in Column C that will return a SSN if it exists in Column A and NOT Column B. If I can't return the actual SSN then just something...
  14. camster39

    All Values in a Filter.....

    Is there a way I can retrieve all the possible values from my auto-filter? For example, I've got an auto-filter setup on a very large spreadsheet. In column B, for example, when I click the drop down I get about 60 or so values. Can I export these values or generate a list of these values? Or...
  15. camster39

    MSAccess Query

    Have a field called "Store Name". Want to create a simple If-then statement that if the value of store name contains "Mike's" then display a "Y" otherwise display an "N". I tried doing something like: Answer: IIf([STORE].[NAME]="Mike's","Y","N") Then I realized that the store name contains...
  16. camster39

    Word - Tables and line spacing

    I've got a basic merge doc that looks like: <<First>> <<Last>> Thank you for your <<Address>> business Mr. <<Last>> <<Address2>> The "thank you for your business" section is in a 16pt bold font and the address info. is in a 10pt regular font. I want...
  17. camster39

    Fill Excel Cell Formula

    Using Excel 2002: Column A Column B Column C Column D 11111 9-15-95 Manager $50,000 10-20-80 Supervisor $40,000 11-10-70 Labor $30,000 An example of a spreadsheet where an employee has multiple...
  18. camster39

    XP Pro - HP 4050 Printer probs....

    I've been using my HP 4050 laser printer for well over a year without any issue. Earlier today I installed my HP 7130 all in one. I honestly don't know if this had anything to do with it but now I can't print at all to my HP 4050 (I haven't used the 4050 in a few days so I can't isolate that it...
  19. camster39

    Blank space in Excel Cell

    Ran a large export from a customer database to MSExcel 2002. Every cell in one of my columns has an extra space in it which is messing up my calculations. For example the cell should show '48993' but instead the true value of the cell is '48993 ' (a space after the 3). I tried formatting the...
  20. camster39

    Satellite broadband to router connection?

    I'm trying to help a friend of mine setup a wireless network. Her broadband modem, provided by DirectTV, does not have a Cat5 connector -- only a USB. How can I convert this USB connection to a Cat5 so that I can plug it into the WAN port on the wireless router? Note: I don't know the...

Part and Inventory Search

Back
Top