#1
|
|||
|
|||
Macro help - search for value, paste a value in another column
Hello,
I'd like some help writing a macro/ script. I want to search for a value ("XYZ-123", case sensitive), then paste another value ("a12345", also case sensitive) in the cell 15 columns to the right of the first value. Then continue that for the entire sheet (a "replace all" sort of function). Thoughts? IR |
#2
|
||||
|
||||
Good afternoon, IRoll. This sounds pretty easy. Do you want someone to write it and you just use it, or would you like to know enough to do it for yourself? If the former, someone like Paul or Peco may (probably will) help you; if the latter, I get a lot more interested. Also, how much do you already know about writing a macro? As I said, this one looks pretty simple; you may not have to learn very much.
On the other hand maybe you're the sort who likes to learn. I'm not trying to discourage you, if you are. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Fomula to search for a string and display value from different column | zeeshanbutt | Excel | 1 | 07-29-2012 12:48 AM |
free slack changes when i paste from fixed cost to cost1 column | ketanco | Project | 5 | 02-03-2012 06:17 AM |
Word Macro to search all tables | silverspr | Word VBA | 3 | 04-02-2011 11:20 PM |
Need to search a column for a macth and return a result from a third column | pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
How to search for email addresses | lacomputech | Word | 2 | 12-10-2009 08:33 AM |