Recent content by cdulong

Thanks Skip!!! That is exactly what I was going for. cdulong

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...

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

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...

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...

Sub Macro1() ' ' Macro1 Macro ' ' Cells.Select Range("G3").Activate Selection.AutoFilter Windows("Book1").Activate Windows("log.log").Activate ActiveSheet.Range("$A$1:$A$3643").AutoFilter Field:=1, Criteria1:= _ "<>*/owa/ &prfltncy*", Operator:=xlAnd...

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...

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...

Worked just as planned!!! THanks!!

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

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,

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...

Thats were it gets tricky. The software does not allow me to spilt the number into two columns.

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...

Thanks!! Works like a charm. CD