Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sweetetc
 
Posts: n/a
Default Copy data from one worksheet to another using a function or a macr

I have two worksheets.

The has two columns that are as follows
19765L819 2
19765H560 1
19765L538 0
19765N435 3

I want to create a function or macro that will list the numbers in column A
the number of times indicated in column B
So the result of the above in a new worksheet column A should look like:

19765L819
19765L819
19765H560
19765N435
19765N435
19765N435
--
Thanks
ETC
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
How can i copy and paste data when there is a filter in the worksheet.... dalipsinghbisht Excel Discussion (Misc queries) 5 March 18th 06 12:38 PM
copy worksheet with formulas but not data Candyk Excel Discussion (Misc queries) 2 October 20th 05 02:22 AM
PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER reegan96 Excel Worksheet Functions 2 April 6th 05 07:17 PM
Copy rows of data to another worksheet where ReturnDate is blank Helen McClaine Excel Discussion (Misc queries) 2 March 28th 05 11:33 PM
Copy data into a NEW worksheet Krefty Excel Discussion (Misc queries) 1 December 22nd 04 01:53 PM


All times are GMT +1. The time now is 07:27 AM.

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

About Us

"It's about Microsoft Excel"