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"