Copying Range Of Data To Next Empty Row

[hkbhansali]

Hi.

I have a spreadsheet where the user enter data into Sheet1 ("Stock").

I want a button with an assigned macro which when clicked,
will select and cut data in (A5:Z5) and paste special Value into next empty row i.e. (A6:Z6).

Then If I overwrite the data in (A5:Z5) the next time I click the macro button,
I want it to paste the data (A7:Z7) into the next available row and so on.

It will not always be the same range of data being selected in Sheet 1 (A5:Z5) may be less or more column.

Thanks in Advance

[dOOb]

Hmm, sorry, maybe it's just me but i'm struggling to follow the logic here.
Can you replace "and so on" with example of the next iteration?

[hkbhansali]

Hi,dOOb
Thanks for reply
some time my data may be A5:Z5, or A5:T5, or may be A5:AC5 means different column,but row is fix 5,
I want cut row 5 whatever Z5, or T5 and paste special value in next empty row.(i.e. start from A6:~)

[kasan]

Try this.

Please Login or Register  to view this content.

[vcoolio]

Hello HKB,

Crikey! How many workbooks do you have?

I was going to suggest the following:-

Please Login or Register  to view this content.

but it looks like Kasan got here before me. Anyway, good luck!

Cheerio,
vcoolio.

[hkbhansali]

Hi, Kasan
Thanks ,
it's work perfect..

[hkbhansali]

Hi,vcoolio

Thanks for help me..