Previous Topic Next Topic

How to create a macro to copy and paste

Closed
johncarr1973 Posts 1 Registration date Wednesday July 12, 2017 Status Member Last seen July 12, 2017 - Updated on Jul 12, 2017 at 02:10 PM
 Blocked Profile - Jul 18, 2017 at 04:50 PM
How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in column A. So in column C I would have the data from column A rows 1-18, then in column D I would have the next 18 numbers in column A.

2 responses

Answer 1 / 2
Blocked Profile
Jul 14, 2017 at 09:18 AM
Open up the MACRO recorder, and record one. Then you can edit it, to change the hardcode stuff into variable to make it flexible. That is how I first learned VBA!
Answer 2 / 2
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Jul 14, 2017 at 10:25 PM
Hello ac3mark,

Just for your info, the OP has received a solution here:-

http://www.ozgrid.com/forum/showthread.php?t=204801

Cheerio,
vcoolio.
Blocked Profile
Jul 18, 2017 at 04:50 PM
That will work. go ahead and script kiddy the solution together, and never understand what you are doing! Right on!

Similar discussions

Why can't I bridge connect?
ryno -
Qiqi -

Hello,
I am needing some advice I have been trying to connect my playstation2 to my laptop via the networking
plugs the 8 wire ones I gather is ethernet but im not sure, now I want the ps2 to connect to my mobile broadband.
so when I open network connections after connecting ps2 it shows four connections two in dial up one being vodafone mobile which is what I use for the net and is 3g and a disconnected 3g one by the same company, now in the LAN or high speed internet section there are two other connects, one is a wireless network connection obviously WiFi but the other is the playstation I guess and it is named Local area connection under that it says
u...

15 responses
How can I make my name text invisible in Discord
imbenmark -
imbenmark -

Hello,
Anyone tried to make name text invisible in discord, I want to make my profile name invisible. How can I do it?

4 responses
Hi Guys how to create an account for facebook with my company em
Ramu -
Ahmadzai -

Hello,
I am Facing a problem while signing up in facebook with my company email so please let me know how to create an account for facebook with my company email
i am getting this error message

It looks like you're trying to create an account for a business, organization or character. Please note that Facebook accounts are used to represent your real identity. Please create a Facebook Page instead.


Configuration: Windows Vista / Firefox 15.0

2 responses
How to bridge connections from laptop to pc
TEchNoob -
Nilesh Katekar -

Hello,

I need to connect my laptop and another computer which runs on Windows . My laptop is currently connect to the internet through wireless ADSL VPN router. I have a LAN cable and a USB to Fast Ethernet Adapter.

the product's web site:
wireless ADSL VPN router : http://global.level1.com/products2.php?Id=650&PC1thId=10

USB to Fast Ethernet Adapter : Davicom, DM9601

Any help is much appreciate.

13 responses
cannot get my home pc to bridge connections
darrenrst -
corona_king -

Hello,
hi all I am trying to set my xbox 360 up using my home pc I have run the ethernet cable strait from my xbox into the ethernet port in the back of the pc! when I try and bridge my connections it ses to create a network bridge you must select at least two LAN or high speed connections that are not being used by internet or connection shareing !!!!!! I have tried everything and it will not work I dont have wireless as its not a laptop. the pc is running vista home how can I get the ethernet port to share with the internet so I can use xbox live please help me thanks

3 responses