Excel 2007 : Tons of data, trying to make copy and paste faster

**gill389** · 11-14-2010, 01:55 PM

I have tons of data and im manually copying and pasting everything. I was wondering if anyone can help. Heres what I am trying to do or am doing and trying to speed it up.

I have in columns, a, b, c, d, e, f. In column B, i have Numbers and then underneath it a name. Once I get to the name in column B i have to copy the adjacent cells C & D, and I do a D9&" "E9 formula. THen I copy and paste special in columns. Then I start again in column B because the name is always chaning.

Anyone now of an easier way, I have about 250,000 rows i need to do manually, its soo boring.

I have enclosed what I have done as an example and what I have been doing.

**martindwilson** · 11-14-2010, 03:26 PM

start at the bottom
see attached b60 =E60&" "&F60
b59=IF(ISNUMBER(C59),B60,E59&" "&F59)
drag upwards

**royUK** · 11-15-2010, 02:07 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.