clean up

background: I have learned so much from this site as well as my own research, but, as you will see, I leanred myself into a corner and would like some direction please. I have this vba code that I use to sort a long list of titles. the code "works", but I would like a way to clean it up. so my...

Hello! I am not really sure how to ask what I need to do, other than ask for suggestions. I have the report that I have to download monthly and compare it with an insurance report from our vendor. The payroll software we use is outdated, but I have no other choice than to use it. Right now...

Hi everyone, I am having a lot of issues with the best method to use for 'cleaning up' my data files in Excel. I currently have 20 files with 10 sheets each to process. I am trying to ---- Take an original sheet and copy it over to another sheet - which will include the 'cleaned' version...

Hi! I am having trouble with cleaning up my data after running analysis on my excel files. I have an excel file where I had to separate a "Name" column into "First" & "Last" name columns. I did this successfully, but now I want to delete the original "Name" column, but I am having trouble...

I recently landed up getting a whole lot of data that I wished was in a csv format. It looks like the data is ready to be printed - fixed width, page number, report name, subtotal on each page... the works.. something from my worst nightmare... It would be great if you could possibly tell me...

I am new to VBA, but I have been trying to figure out a way to simplify this process -- when I took over the project, I was told it would take me between 3-5 days/month to clean up! After playing around with If statements and various functions, I have been able to reduce the time significantly...

Hi, I have a complex problem. I have a heap of data in excel that has a lot of crap in between, below is an example. It lists a Job Number (i.e A1), then a heap of crap I don't care about until it gets to the data blocks that each have the heading "REPORT" with a few rows of data for that...

Hi All, I have a data set of about 20k rows, exported from a not so friendly DB, that has blanks all over. It is causing havoc with my VB and Dates! Can anyone help me to TRIM all the data. Ideally some VB just to pop into the clean up loop I have on for formatting. Any advice would be...

Hi Guys I hope someone with more VBA than I have can help. I am trying to create code to clean up a sheet. What I need is to test the values in Column "T" starting at "T2". The cells in this column contains either a space or a delete flag (set at 1). If the flag is set to "1" I need to delete...