Jump to content
Sign in to follow this  
jjautoit

MS Excel- Find and Replace multiple values

Recommended Posts

I am a newbie and need some scripting help.

I am workin on a big excel spreadsheet and I need a script for finding and replacing multiple values.

Basically what I need to do is:

1. I have two array values that needs to be added/replaced.

2. The script looks for a cell that contains the first value in an array1.

3. If finds the first array value on a given row.

4. Inserts a new row below.

5. Adds the first value from array2.

6. Repeat until all array2 values are inserted (inserting a new row for each array2 value).

7. Repeat 2-7.

I know the Find/Replace function in excel only finds/replaces a single value. There must an easier way using AutoIt since I have some 1200+ rows to work with.

If anyone has worked with AutoIt and Excel please give me some pointers. I really appreciated it.

Share this post


Link to post
Share on other sites

I am a newbie and need some scripting help.

I am workin on a big excel spreadsheet and I need a script for finding and replacing multiple values.

Basically what I need to do is:

1. I have two array values that needs to be added/replaced.

2. The script looks for a cell that contains the first value in an array1.

3. If finds the first array value on a given row.

4. Inserts a new row below.

5. Adds the first value from array2.

6. Repeat until all array2 values are inserted (inserting a new row for each array2 value).

7. Repeat 2-7.

I know the Find/Replace function in excel only finds/replaces a single value.  There must an easier way using AutoIt since I have some 1200+ rows to work with.

If anyone has worked with AutoIt and Excel please give me some pointers.  I really appreciated it.

<{POST_SNAPBACK}>

Until COM goes in, the only way is to write a VB script.

Lofting the cyberwinds on teknoleather wings, I am...The Blue Drache

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...