actual row number

C

climate

I have 63 file.
My data set on to column X, and G2 is row number related to column X.
I need to macro or formula, when run it on any file, copy of column X paste
to new file(R.xls) in sheet1 on column H and set to actual row number. For
example: G2 is 7800 (row number), now, run macro, then copy of column X,
paste to actual row (H 7800) of new file (R.xls), When open second file, (G2
is 5344), column H copy to R.xls and set to H5344. This process is repeated
on 63 file.

Thank’s for any help.
regards
 
C

climate

I have 63 file.
My data set on to column X, and G2 is row number related to column X.
I need to macro or formula, when run it on any file, copy of column X paste
to new file(R.xls) in sheet1 on column H and set to actual row number. For
example: G2 is 7800 (row number), now, run macro, then copy of column X,
paste to actual row (H 7800) of new file (R.xls), When open second file, (G2
is 5344), column H copy to R.xls and set to I5344. This process is repeated
on 63 file
 
C

climate

climate said:
I have 63 file.
My data set on to column X, and G2 is row number related to column X.
I need to macro or formula, when run it on any file, copy of column X paste
to new file(R.xls) in sheet1 on column H and set to actual row number. For
example: G2 is 7800 (row number), now, run macro, then copy of column X,
paste to actual row (H 7800) of new file (R.xls), When open second file, (G2
is 5344), column H copy to R.xls and set to I5344. This process is repeated
on 63 file.

Thank’s for any help.
regards
Click to expand...
 
C

climate

climate said:
I have 63 file.
My data set on to column X, and G2 is row number related to column X.
I need to macro or formula, when run it on any file, copy of column X paste
to new file(R.xls) in sheet1 on column H and set to actual row number. For
example: G2 is 7800 (row number), now, run macro, then copy of column X,
paste to actual row (H 7800) of new file (R.xls), When open second file, (G2
is 5344), column H copy to R.xls and set to I5344. This process is repeated
on 63 file.

Thank’s for any help.
regards
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column corresponding to row number 0
Data moving 3 1
Data moving 3 5
copy rows to another file 0
MS Project Import Error Row 1 Column 5 2
Working outlook via vba code with xlsx - error 0
Need Help with a VBA subroutine 0
copy rows to another file 3

Top