Excel Job by shaunycc


I've got an excel file that I need to make a lot of changes to and I need to do this every week so I could do with a macro or VBA to do it all.

All this needs to apply to [url removed, login to view]

1. Remove just the words in brackets (including the brackets)"(*)" from column A

2. Remove just the dash and any words that come after it "- xx" in Column A

3. Remove entire row if "GONE" is in column K

4. Divide value in column X by value in Column V

5. After doing 4 above If value in column X = more than 5 and value in column L = less than 10 (delete entire row)

6. After doing 4 above If column X = more than 10 and value in column L = less than 20 (delete entire row)

7. columm E contains the name of picture files that need to be prepended with MYWORD and appended with MYNUMBER before the .jpg eg. "????.jpg" = MYWORD????[url removed, login to view] same needs to be done for .gif files

8. column F contains the name of a text file in each cell (which are located in the same folder as the [url removed, login to view] file), I need the contents of the text file to replace the text file name. (maintaining formatting as its the synopsis of books)

9. Column B contains a list of 200 different titles repeated randomly 1000's of times. I have a seperate csv file "replacecolumnb.csv" with the 200 titles in column A and the number I want them replaced with in column B. I need to use this file to search and replace the titles in column B in my [url removed, login to view]

10. Column C contains titles some are prepended by publisher names I have a seperate file with a list of publishers in column A called [url removed, login to view] If one of the publisher names in [url removed, login to view] matches the first words of titles in column C in [url removed, login to view] then I need that publisher name to replace what is in column A of [url removed, login to view]

eg: silent hill in [url removed, login to view] would match "silent hill tales of life" but not "penguin silent hill" or "silent times" etc a match would replace the cell in column A with "Silent Hill"

Skills: Excel

See more: custom list in excel, what is vba in excel, what is vba, what is macro in excel, vba project f, vba e, picture books, penguin 20, or 4 names are in the same column, macro e, cell names, excel macro row, excel delete cell contains, excel macro csv, excel macro delete text, seperate cell, need match files excel, excel delete row, excel vba macro file, remove vba excel, project macro, macro vba cell, excel custom number, vba file list excel, excel vba remove

About the Employer:
( 1 review ) Leeds, United Kingdom

Project ID: #2467502

Awarded to:


Hired by the Employer

$60 USD in 1 day
(209 Reviews)