KatSmith
03-24-2012, 01:56 PM
Hello,
I have searched your forum and can't dins anything that specifically addresses the two macro challenges that I have.
Challenge 1
I have a sample file attached Tab 1 is Sample1 and the second tab is Sample 2.
Sample 1 shows the initial file, and Sample 2 a short exampl of what I am trying to achieve.
What I need is a macro that will insert two columns to the left of column A, then copy Agent's Name in (D) and the Date in (H) into the new columns. Now the challenge is that not every sequence is the same number of rows. Some have comments, some don't, so I can say to copy say 10 rows and move the the next evaluation. The macro will have to read and identify the original column A cell where is says "Agent Name:" as the breaking point to then pick up and copy & past the name and date in the next evaluation. There is a possibility that the file can be over 500 rows, so I would need this to loop until the macro did not identify the trigger
Challenge 2
This needs to be a separate macro, and not part of the first one. I would like a input box to pop up and ask me the the first 5 to 10 characters of a row that I want to delete. So, if I wanted to delete the row that begins with " NC05 __________ Call Control/Time Management" them I could input 'NC05" into the box and the the macro would loop through the file and delete all instances of this. I know I can do this with a replace, but that still leaves the empty row.
Can someone help me with this? I would greatly appreciate any assistance you can provide to me.
:dunno :banghead: :help
I have searched your forum and can't dins anything that specifically addresses the two macro challenges that I have.
Challenge 1
I have a sample file attached Tab 1 is Sample1 and the second tab is Sample 2.
Sample 1 shows the initial file, and Sample 2 a short exampl of what I am trying to achieve.
What I need is a macro that will insert two columns to the left of column A, then copy Agent's Name in (D) and the Date in (H) into the new columns. Now the challenge is that not every sequence is the same number of rows. Some have comments, some don't, so I can say to copy say 10 rows and move the the next evaluation. The macro will have to read and identify the original column A cell where is says "Agent Name:" as the breaking point to then pick up and copy & past the name and date in the next evaluation. There is a possibility that the file can be over 500 rows, so I would need this to loop until the macro did not identify the trigger
Challenge 2
This needs to be a separate macro, and not part of the first one. I would like a input box to pop up and ask me the the first 5 to 10 characters of a row that I want to delete. So, if I wanted to delete the row that begins with " NC05 __________ Call Control/Time Management" them I could input 'NC05" into the box and the the macro would loop through the file and delete all instances of this. I know I can do this with a replace, but that still leaves the empty row.
Can someone help me with this? I would greatly appreciate any assistance you can provide to me.
:dunno :banghead: :help