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!

Register Log in
  • 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: cdulong
  • Content: Threads
  • Order by date
  1. cdulong

    Loop for ChechBoxes

    Im trying to create a loop that will go through a list of 27 Check boxes and perform a specific action based on the value of the check box. I think I am close with my script but I keet getting an error when I execute. Mismatch error. Could someone take a look at my logic and let me kow where...
  2. cdulong

    Merging data from two excel spreadsheets

    Hello, I am looking for a script or method to merge data from two Excel spreadsheets. The data is set up as follows: Sheet 1 Name Age Bill 11 Charles 14 Aaron 16 Sheet 2 Name Weight Bill 200 Jim 240 Charles 220 Aaron 190 James 185 Expected results: Sheet 3...
  3. cdulong

    Need to know what this does?

    I found a batch file online that is programmed to delete files in a folder older than 3 days. The problem I am having is there is a line I am not 100% about. dir /b /a-d 2^>NUL I do understand that this commnand will output the contents of a folder with only file name and no header or footer...
  4. cdulong

    Delete Rows that do not contain data

    I am working in excel and I am trying to create a macro that will delete all rows that do not contain a specific value. The problem I am running into is that the text I am looking for is in the middle of the cell and not sure show to perform the lookup. The column that contains the data I am...
  5. cdulong

    Excel - Print multiple files

    I am looking for a way to print multiple files at one time. Every month we close month end and have to print out a financial statement for each location. Each location has their own excel file, within each file there are a number of tabs (worksheets), one for each different month, plus one...
  6. cdulong

    Macro to remove extra digits

    I am looking for a way to remove extra digit from some of our account code. Here is how the accounting software outputs the information 4101-002 4505-060 4501-100 What I need it a macro or script to remove the 0's on the right of the - up to the first digit that is not a 0 giving the...
  7. cdulong

    grouping accounts

    I am exporting a list of accounts with balances into an excel spreadsheet and I am having an issue with sorting/grouping the accounts. What is currently is happening is when I open the file all the acounts are in numerical order (which is normal for excel) and are list as such 4101-002...
  8. cdulong

    Add a "-" in the middle of a string

    I need a formula that will add a "-" after the fourth character of a string, then add the remainder of the string after the "-". Thanks,
  9. cdulong

    add number to string

    I currently have this in a macro that will help me disable buttons. what i am trying to accomplish is as each time the loop goes through it will re populate B28 with: Button 2 Button 3 and so on a = 2 Do While a <= 10 But = "Button " But = But & a...
  10. cdulong

    Button text equals cell value

    I currently have a sheet that has a form button that a user can press to go to a administration sheet. I want to be able to change the text on the button dynamically. If E6 = 11 I would like the text on the button to read "Admin" If E6 <> 11 I would like the text on the button to read...
  11. cdulong

    How to lock cells based on another

    Hello, I am looking for a method (probably a macro of some sort) that will lock a range of cells (c24:f24) if another cell(B30) has a value of ""(empty), I have looked around and found some code to perform this but I can't figure out exactly were to put it and how to properly make it run. Just...
  12. cdulong

    How to lock cells based on another

    Hello, I am looking for a method (probably a macro of some sort) that will lock a range of cells (c24:f24) if another cell(B30) has a value of ""(empty), I have looked around and found some code to perform this but I can't figure out exactly were to put it and how to properly make it run. Just...
  13. cdulong

    Vlookup help

    Hello I am having a issue with vlookup and am looking for some assistance. The formula that I am currently using is as follows: =VLOOKUP(Index!B6,G10:H17,2,FALSE) Index!B6 = 2009 G10:H17 is as follows 2008 12/23/2007 2009 12/21/2008 2010 12/20/2009 2011 12/19/2010 2012 12/18/2011 2013...
  14. cdulong

    Excel Formula to populate Payperiods

    I am having trouble creating a formula that will populate payperiods for a given year. The end user would enter the year (ie. 2009) and the sheet would populate with the payperiods for that year. Some of the features would be payperiod 1 is the payperiod in which jan 1 falls. Do I need to have...
  15. cdulong

    exprot to editable rtf

    I am trying to export my report to an editable rtf file, everyting works great except for the page number. Each page is page 1. Any suggestions or work arounds?
  16. cdulong

    dynamic parameter

    I am trying to put the finishing touches on a seniority report. This is what I have so far: -> 2 Tables - Full Time & Part Time -> Each table contains hours of seniority based on class (full time & part time) I have two different reports a full time report and a part time report, my full time...
  17. cdulong

    Export to Excel Page Breaks

    Not sure why this is happening.... When I export to excell I select the "Create page break for each page" option but when I go and open the file in Excel I have to move the page breaks around to get the report to fall on the right pages again. Am I missing something? I have tried adjusting...
  18. cdulong

    selection formula

    I need a selection formaula that work with the following information. Each record has two fields which are defined as dates: {table.Date of Transfer In} and {table.Date of Tranfer Out} What I am looking for is a formula that will select the records that have dates between two dates. Some...
  19. cdulong

    Years of Service

    I am looking to create a formula that will show years of service. I have a table with a field with their start date. What I need is a formula that I could use to get years of service from today. I tried: currentdate-{table.field} I am not getting the results taht I need. Any help would be...
  20. cdulong

    Today - 2 years

    I need to create a selection forumla that will show only employees that have a 'startdate' within the last two years. any help would be greatly appricated. Thanks, cdulong

Part and Inventory Search

Back
Top