Copy and Pasting Every Third Row
I have a large spread sheet that has two different but associated pieces of information in the same column (size and color). I'm looking for a fast way to have the contents of every third cell be cut and pasted into a column right beside the information directly above it (e.g. the color in E3 to be moved into F2, which would be next to its associated size in E2). This gets to be done several hundred times per spread sheet (moving E3, E6, E9 . . ., ect to F2, F5, F7 . . ., etc) and would be so much faster if there is an automated way to do it. I have limited knowledge of Excel and don't know whether a simple function or macro is available to do this. Any assistance is greatly appreciated. Thanks so much! -- teo2099 ------------------------------------------------------------------------ teo2099's Profile: http://www.excelforum.com/member.php...o&userid=26642 View this thread: http://www.excelforum.com/showthread...hreadid=399176 |
All times are GMT +1. The time now is 11:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com