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 Wanet Telecoms Ltd 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: *

  1. cdulong

    Loop for ChechBoxes

    Thanks Skip!!! That is exactly what I was going for. cdulong
  2. 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...
  3. cdulong

    Merging data from two excel spreadsheets

    Thanks!!! That is exactly what I was looking for. cdulong
  4. cdulong

    Merging data from two excel spreadsheets

    ...220 Aaron 190 James 185 Expected results: Sheet 3 Name Age Weight Bill 11 200 Charles 14 220 Aaron 16 190 * If the name appears in the first sheet it needs to appear in the third sheet with the coresponding value from the second sheet. Any help would be...
  5. 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...
  6. cdulong

    Delete Rows that do not contain data

    ...Windows("Book1").Activate Windows("log.log").Activate ActiveSheet.Range("$A$1:$A$3643").AutoFilter Field:=1, Criteria1:= _ "<>*/owa/ &prfltncy*", Operator:=xlAnd Rows("2:3643").Select Selection.Delete Shift:=xlUp Range("B63").Select...
  7. 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...
  8. 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...
  9. cdulong

    Macro to remove extra digits

    Worked just as planned!!! THanks!!
  10. cdulong

    Macro to remove extra digits

    I am fairly new to these types of scripts and I cannot get it to run correctly. What I am looking for is to select cells A1:A1000 and click a button that remove the excess 0's. Hope you can help with this thanks
  11. cdulong

    Macro to remove extra digits

    Thanks for the help I am using visual basics for excel. If you could re write it so that I can use it there that would be great. THanks,
  12. 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...
  13. cdulong

    grouping accounts

    Thats were it gets tricky. The software does not allow me to spilt the number into two columns.
  14. 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...
  15. cdulong

    Add a &quot;-&quot; 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,
  16. cdulong

    add number to string

    Thanks for your help but I ended up scrapping the idea that I going to use. Thanks,
  17. cdulong

    add number to string

    there isn't all it gives me is Runtime error '13': Type Mismatch
  18. cdulong

    add number to string

    thanks but that didn't work I was still giving the same error
  19. 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...

Part and Inventory Search

Back
Top