replacing value

[daveyc18]

when I copy and paste certain data, there's always certain values that need to be changed.

ex

A100= daveyc18

B100 = 1,000

but I always need to replace B100 with = 20,000 every day.

in OTHER rows,

A200 =batman
A201 =batman
A202 = batman

B200 = 1,000
B201 = 1,100
B203 = 1,200

And I need to manually change B200-203 to 2000,3000,4000 every day.

I can this can be automated, but the trick here is the row numbers change every day. for example, the daveyc18 row can be 150 one day, and the next day it can be in row 160.

so, i'm wondering replacing these numebers can be done automatically...again, the numbers that are using to replace the original values are the SAME every day (e.g, daveyc18 ...always using 20,000....batman, always using 2000,3000, 4000)

[ragavan.sridar1]

Please Login or Register  to view this content.

[daveyc18]

looks OK, but there are three rows of "batman," and each row of "batman" needs to be adjusted for a new value...not only 2000...but the other rows 3000 and 4000

[xladept]

Hi daveyc,

Altering raga's a little:

Please Login or Register  to view this content.

[daveyc18]

Doesn't seem to be working..ill be clearer...

the text values "daveyc18" and "batman" are in column G....and the values that need to be adjusted daily are in column K

so...daveyc18 = G100...on same row....change K100 from 1,000 to 20,000

again, these rows wont be on the same rows every day...so daveyc18 could be on G150 the next day

thank you

[xladept]

Hi daveyc,

See if this fixes it:

Please Login or Register  to view this content.

[jindon]

Do you man like this?

Please Login or Register  to view this content.

[daveyc18]

Worked perfectly. Thanks!