BANDI MAHA
Member
Members
Forum Posts: 23
Member Since:
July 20, 2020
July 20, 2020
Offline
Good morning and happy new year everyone ^ _ ^ Admin, I have a trouble to copy and paste cells and removing empty columns based on the existing column
please help me create the correct copy and paste code based on this sample file ... thanks for taking the time to respond to my request
Purfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019
Offline
There is no code in the attached workbook to review?
This is limited, but should start you off, the easist way to remove blank rows is to sort the data after pasting
Sub CopyPaste()
Worksheets("Sheet1").Range("c4:d24").Copy Worksheets("Paste").Range("c5")
Worksheets("Paste").Range("c4:d24").Sort key1:=Range("c4"), order1:=xlAscending, Header:=xlYes
End Sub
Also get rid of the merged cells in row 3, they will only cause you pain
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: John Steele
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30159
Member Stats:
Guest Posters: 49
Members: 33703
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —