Row Selection Against the Cell value

[Liju144]

Dear Friends,

i need a help in Macro,

I need to copy the Rows against the Cell value
Example:- if sheet1 cell A1 value is 5 then i need to copy the first 5 rows of sheet2 and paste in to sheet3.


Thanks

Liju

[XOR LX]

Hi,

The entire row? 16384 columns?

Regards

[Liju144]

Thanks,

Not the Entire row only Which count is given in Sheet1 A1 Cell that much row, and all columns..

(row selection cound is depend up on the Sheet1 A1 Cell)

[XOR LX]

You have data in the entire row (which, by they way, means you have data in 16,384 columns, from column A to column XFD)?

Regards

[Liju144]

No data the Entire column Maxiumum BA column

[XOR LX]

Try this code:

Please Login or Register  to view this content.

Regards

[Liju144]

Thank you Friend,


I have one more chalenge in this is ts possible in filter mode ??

if the Sheet2 is filered data then how?? its work

[Liju144]

Dear Friend,

if posible the starting range also asing a cell value???

Thanks
Liju M

[XOR LX]

Dear Friend,

if posible the starting range also asing a cell value???

Thanks
Liju M

Hi.

Sorry - not sure what you mean by this. Can you give an example?

Regards

[Liju144]

Actually i have a data range some days i need to move a count of data to another sheet and moved data marked as done and balance data next day will move a count the same will continue..

[XOR LX]

Sorry - still don't understand.

Kindly upload a workbook with your desired results clearly outlined.

Regards

[Liju144]

Dear

Thank for replaying find the attachment

[XOR LX]

Sorry but this appears to have nothing to do with the original request in this thread.

I believe you should be starting a completely new thread for this with an appropriate thread title.

Regards