Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default adding rows and populating them with data from other columns

i need to add 10 empty rows after each non-empty row and copy data fro
other columns and paste it within the empty row. how should i go abou
doing it

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 56
Default adding rows and populating them with data from other columns

Hi Shirley
Are you copying data from the same sheet within the same workbook?
How many columns are involved?

Cordially
Pascal

"shirley " a écrit dans le message
de ...
i need to add 10 empty rows after each non-empty row and copy data from
other columns and paste it within the empty row. how should i go about
doing it?


---
Message posted from http://www.ExcelForum.com/



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default adding rows and populating them with data from other columns

yes, the copy and paste is within the same sheet. i'm looking at abou
140 column

--
Message posted from http://www.ExcelForum.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADDING COLUMNS FOR COMMON ROWS JGAVIGAN Excel Discussion (Misc queries) 2 April 9th 10 03:06 AM
keep formulareferenses when adding columns or rows vito Excel Discussion (Misc queries) 3 April 8th 09 09:05 AM
adding more columns/rows Jo Davis Excel Discussion (Misc queries) 4 September 24th 08 07:57 PM
Adding up columns for speciic rows confused Excel Worksheet Functions 1 March 3rd 08 04:16 PM
adding specifics columns and rows yodochi Excel Worksheet Functions 1 July 25th 07 03:24 AM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"