clean up

  1. E

    Best approach for 'Cleaning' Multiple Excel Files

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

    How to successfully delete formula dependent columns

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

    Cleaning up data - Fixed width + page print format

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

    Cleaning Up AR Aging Detail Report Using Visual Basic --- If...Then? Offset? ...?

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

    Tidying up data in Excel...

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

    Trimming Blanks using VB

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

    VBA code to clean up a sheet (Entire Row Delete)

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

Some videos you may like

This Week's Hot Topics

Top