Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Export Data on new Sheet with same Id of that column
First of all let me tell you all that i am totally new to Excel. I never used it before.. I am in a little trouble, so i need help of your guyz... Hope you guyz will help me.
My Problem is : I have two columns "Sr.No" and "Previous Posting" as showing in the image 1 (Current Situation). Sr.No columns contains numbers in series and "Previous posting" contains all the posting details in the same column but in different rows.. Now i want to save all these posting details in a new sheet but not in a single column. Every posting detail should be in a new row with same Serial Number which belongs to that column, rather than all the posting record in a single column. Results should be like as showing in image 2: I hope you will understand my question and suggest me how to do this as i am totally new. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Export Data on new Sheet with same Id of that column
Hi,
Am Sat, 21 Feb 2015 08:16:32 +0000 schrieb randhawa_125: +-------------------------------------------------------------------+ |Filename: Untitled2.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=1006| +-------------------------------------------------------------------+ please upload a workbook instead of a picture Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
|
|||
|
|||
Quote:
Sub DuplicateValuesInColumnA() Dim a, b As Long Columns("A").Select Selection.UnMerge a = Range("M" & Rows.Count).End(xlUp).Row - 2 For b = 0 To a If Range("A2").Offset(b, 0) < "" Then Range("A2").Offset(b, 0) = Range("A2").Offset(b, 0) Else: Range("A2").Offset(b, 0) = Range("A2").Offset(b - 1, 0) End If Next b End Sub
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Export specific data in a sheet in a new row | Excel Programming | |||
Export Data into another sheet | Excel Discussion (Misc queries) | |||
export sheet data for batch script | Excel Programming | |||
export excel data to another sheet | Excel Programming | |||
can I export just the autofiltered data into own sheet? | Excel Discussion (Misc queries) |