PC Review


Reply
Thread Tools Rate Thread

about data copting

 
 
pmss
Guest
Posts: n/a
 
      23rd Jan 2008
hello
i have a lot of data series in one column A1, A2.......An. i wanted to copy
these data and paste in another sheet with first 10 number of data in first
row and from 11 in second row ... I have used following macrows code:

Dim lastrow As long, lastCol As Long
Dim rng As range, i As long
With Worksheets("sheet1")
lastrow = .Cells(Rows.Count,1). End(X1Up).Row
For i = 1 To lastrow Step 11
Set rng = worksheets("sheet2")_
..Cells(rows.count,1).End(X1Up)(2)
lastcol = .Cells(i, 256).End(X1Toleft).Column
..Cells(i,1).Resize(11,lastcol).copy
rng.PasteSpecial x1value, Transpose:= True
Next
End with

It works properly but i need that after every 365 data it will start from
new row. One more thing is it possible to link some data from another cell
sothat it repeats every time after 365 data.

Thanks

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry dataentryoffshore@gmail.com Microsoft Excel Programming 0 4th Jun 2008 04:02 PM
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry dataentryoffshore@gmail.com Microsoft Excel Programming 0 4th Jun 2008 04:00 PM
Professional Data Conversion,Data Formats and Affordable Data EntryServices by Data Entry India Data Entry India Microsoft Access Form Coding 0 31st Mar 2008 11:50 AM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing admin.dataentryoutsourcing@gmail.com Microsoft Excel Misc 0 20th Mar 2008 12:45 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing admin.dataentryoutsourcing@gmail.com Microsoft Access Form Coding 0 20th Mar 2008 12:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:19 AM.