Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 5th 08, 03:47 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 11
Default Copy down repetitive rows

I have a string of data that I need to populate in repetition down several
thousand lines for my filter strings to work properly. Right now, I am
copying and pasting. Is there a function I can use to make this task easier?
See below, I need to repeat the rows to associate all related data in each
row for my filter string, same as UD73-00185:
UD73-00185
UD73-00185
UD73-00185
00377BC


100AC


C-01AC




  #2   Report Post  
Old March 5th 08, 05:27 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Copy down repetitive rows

Are you trying to fill the empty cells with the value in the previous used cell?

If yes, the check out Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

Lowkey wrote:

I have a string of data that I need to populate in repetition down several
thousand lines for my filter strings to work properly. Right now, I am
copying and pasting. Is there a function I can use to make this task easier?
See below, I need to repeat the rows to associate all related data in each
row for my filter string, same as UD73-00185:
UD73-00185
UD73-00185
UD73-00185
00377BC

100AC

C-01AC


--

Dave Peterson
  #3   Report Post  
Old March 6th 08, 02:48 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 11
Default Copy down repetitive rows

This works Great!

"Dave Peterson" wrote:

Are you trying to fill the empty cells with the value in the previous used cell?

If yes, the check out Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

Lowkey wrote:

I have a string of data that I need to populate in repetition down several
thousand lines for my filter strings to work properly. Right now, I am
copying and pasting. Is there a function I can use to make this task easier?
See below, I need to repeat the rows to associate all related data in each
row for my filter string, same as UD73-00185:
UD73-00185
UD73-00185
UD73-00185
00377BC

100AC

C-01AC


--

Dave Peterson



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
Sorting rows of repetitive data S R Burns New Users to Excel 1 April 30th 07 07:33 PM
Repetitive Numbers Katelyn Excel Discussion (Misc queries) 1 February 19th 07 08:50 PM
Repetitive keystroke Andre Croteau Excel Discussion (Misc queries) 3 October 7th 06 02:20 AM
repetitive Repetitive formula Excel Discussion (Misc queries) 2 June 28th 06 05:59 AM
SORT REPETITIVE DATA FROM ROWS TO COLUMNS Mitch Excel Worksheet Functions 9 June 24th 06 05:27 AM


All times are GMT +1. The time now is 06:02 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017