change position of data

[climate]

Hi
My data set, has located on column x, for example: (x2:x570),i want to move
this column to desired row number (x7644).
I need to a macro or function, when run it, then at first, open the Box, and
take me new row number, and finally, move data on column x to new row number
(x7644:x8214).

I have many file and little time.

Thank's for any help.

best regards

 

[Don Guillett]

open the Box???
Insert rows???

 

[climate]

I have many files.
Any file has data on column X and special range.
I need to a code when run it on any file, open Box similar to following:
response=InputBox("Enter new row number") and after i input row number,
then copy of data on column X and it's Range, paste to new row number on
sheet2.
Example for first file: data on column X has Range (X2:X570), new row number
in Box is 7644. after run code, copy of data paste to sheet2 and new Range
(X7644:X8214).

regards

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.