Find and Replace

elgringo56 · May 13th, 2002, 07:09 PM

Ok, lets see if I can get off on a little better foot here. I have a list that is 40 columns wide and 10000 rows deep. I Filtered it and found a single entry. I then Modified that entry and now want to replace the original entry in my list with the modified one. I have searched help, but I find that if you dont know much about VB, its pretty hard to find anything in help. Seems to me it was written for folks that already know all about VB in excel, neither here nor there. Any one know how to do what it is I need, I would appreaciate it very much

NateO · May 13th, 2002, 07:23 PM

If you simply filtered the list, modified the entry then removed the filter, the entry should be modified, or I am missing something.

Wonder how the list was filtered. If you reapply the filter, does the original data appear?

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-13 18:27 ]

brettvba · May 13th, 2002, 07:23 PM

Ok if I understand what your saying you want to find and replace a value?
This value will now be changed so Im not to sure what your really asking?
if you filter get one line and change it , its changed
please elaborate

elgringo56 · May 13th, 2002, 07:29 PM

I did an auto filter and copy. this leaves the line in the list. I took what was copied out and may or may not have modified it. If I did modify, I want to again find the original entry in the list and replace it with any modifications I made to that entry. the entry is 40 columns wide and sever cells in it may have been modified.

elgringo56 · May 13th, 2002, 07:31 PM

And, yes nate, the orginal data will appear if another filter operation is done, I dont want to remove the original entry until I know something was changed in it so I used autofilter with copy to pull it out to see. If no changes are needed, I discard the copy and go my merry way, no changes needed to the list

elgringo56 · May 13th, 2002, 07:42 PM

A little clearifcation on my question. Everything I am doing here I am doing from within a macro, so I never actually see the filter, only the result of it. I need to replace it into the list by macro, also.

brettvba · May 13th, 2002, 07:45 PM

ok I understand now
you could do a find and replace with macro what kind of data are you changing
for eg find a code/Description for a product then change data about that product ?

elgringo56 · May 13th, 2002, 07:48 PM

something like that, I have a part number that is unique for each row of data in the list. from that I filter for that item. all other cells can be changed. I am not sure how to use the find and replace as it applies to whole rows of data, In fact I have never used find and replace. Not to experienced here. Sorry

brettvba · May 13th, 2002, 07:52 PM

ok so if you had a product code
say 123456
you enter that into an inputbox it finds that on the sheet and then you can change that cell or in your case the cells around it with code is that what your after.

enter 123456 in the input box and change a cell 3 cells to the right.for example@

elgringo56 · May 13th, 2002, 07:53 PM

yes, I want to change some 38 cells to the left of it with my new data

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 07:09 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Ok, lets see if I can get off on a little better foot here. I have a list that is 40 columns wide and 10000 rows deep. I Filtered it and found a single entry. I then Modified that entry and now want to replace the original entry in my list with the modified one. I have searched help, but I find that if you dont know much about VB, its pretty hard to find anything in help. Seems to me it was written for folks that already know all about VB in excel, neither here nor there. Any one know how to do what it is I need, I would appreaciate it very much

May 13th, 2002, 07:23 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	If you simply filtered the list, modified the entry then removed the filter, the entry should be modified, or I am missing something. Wonder how the list was filtered. If you reapply the filter, does the original data appear? _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-13 18:27 ]

May 13th, 2002, 07:23 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Ok if I understand what your saying you want to find and replace a value? This value will now be changed so Im not to sure what your really asking? if you filter get one line and change it , its changed please elaborate

May 13th, 2002, 07:29 PM	#4
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	I did an auto filter and copy. this leaves the line in the list. I took what was copied out and may or may not have modified it. If I did modify, I want to again find the original entry in the list and replace it with any modifications I made to that entry. the entry is 40 columns wide and sever cells in it may have been modified.

May 13th, 2002, 07:31 PM	#5
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	And, yes nate, the orginal data will appear if another filter operation is done, I dont want to remove the original entry until I know something was changed in it so I used autofilter with copy to pull it out to see. If no changes are needed, I discard the copy and go my merry way, no changes needed to the list

May 13th, 2002, 07:42 PM	#6
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	A little clearifcation on my question. Everything I am doing here I am doing from within a macro, so I never actually see the filter, only the result of it. I need to replace it into the list by macro, also.

May 13th, 2002, 07:45 PM	#7
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	ok I understand now you could do a find and replace with macro what kind of data are you changing for eg find a code/Description for a product then change data about that product ?

May 13th, 2002, 07:48 PM	#8
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	something like that, I have a part number that is unique for each row of data in the list. from that I filter for that item. all other cells can be changed. I am not sure how to use the find and replace as it applies to whole rows of data, In fact I have never used find and replace. Not to experienced here. Sorry

May 13th, 2002, 07:52 PM	#9
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	ok so if you had a product code say 123456 you enter that into an inputbox it finds that on the sheet and then you can change that cell or in your case the cells around it with code is that what your after. enter 123456 in the input box and change a cell 3 cells to the right.for example@

May 13th, 2002, 07:53 PM	#10
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	yes, I want to change some 38 cells to the left of it with my new data