Completed

looking for a macro to search and replace a number within rows and the do the same in the next row but add consecutive number

i have a csv file with one row, i copy and paste the row 50 times

four of the columns (H, I, N, BJ,) have text including a number in them ie A1123, (the same number in each column )

i am looking for a macro / script to search for "A1123" in each row and replace the number with the next consecutive number, right through the 50 rows

so each row has consecutive numbers within the four columns

ie row 1 will have A1123 in the 4 x cells

row 2 will have A1124 in the 4 cells

i have attached an example of what i mean

ect ect

Kemahiran: Excel

Lihat lagi: consecutive add, consecutive, to search, rows, replace, h and h, macro script file, excel macro add, excel row column, excel macro row, excel macro csv, copy csv excel, excel column row, excel 2013 macro, csv excel text, search replace script, text row, excel text rows, add excel macro, column row excel

Tentang Majikan:
( 71 ulasan ) Hadleigh, United Kingdom

ID Projek: #4891134

Dianugerahkan kepada:

Teloquence

Will do it in 1 hour. Check my past reviews for your reference.

$20 USD dalam 0 hari
(98 Ulasan)
5.9

11 pekerja bebas membida secara purata $22 untuk pekerjaan ini

sy3d

interested in your project, please check pm .. thx

$30 USD dalam 0 hari
(117 Ulasan)
6.3
maverick44000

Hi John. Consider it done in 2 hours. Regards

$35 USD dalam sehari
(8 Ulasan)
4.4
expertatwork

Get this done in an hour :-)

$13 USD dalam sehari
(30 Ulasan)
3.9
excel4engineers

I made such code before. It was like replace SKU codes at each column. Please refer to my private message.

$20 USD dalam sehari
(9 Ulasan)
3.4
pawankhurana

Hi Let the Expert Deal with It Regards Pawan

$25 USD dalam sehari
(4 Ulasan)
2.0
elMancha

Hello. I have high excel and VBA skills with great professionalism. Check PM please.

$14 USD dalam sehari
(5 Ulasan)
1.9
dcart

Hi, I have the capacity to do this. Would you considered my bid?

$25 USD dalam 3 hari
(1 Ulasan)
1.5
danaldea

Half an hours worth of work. Happy to help.

$10 USD dalam 0 hari
(1 Ulasan)
1.5
manujain90

Hello, I am working as a Business Analyst in one of the world's biggest pure play analytics company. My daily work is to simplify and solve business problems by creating excel tools for the client and doing analysis Lagi

$25 USD dalam 3 hari
(0 Ulasan)
0.0
sarawriter

I'm ready to start....

$30 USD dalam 3 hari
(0 Ulasan)
0.0
anmoni

i will do this

$25 USD dalam 3 hari
(0 Ulasan)
0.0