If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
actual row number
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 |
#2
|
|||
|
|||
actual row number
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 |
#3
|
|||
|
|||
actual row number
"climate" wrote: 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 |
#4
|
|||
|
|||
actual row number
"climate" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|