LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default VBA to create new data help please

I have 4 different sets of datalists currently.

Dataset A, with values A1, A2, A3,....
Dataset B, with values B1, B2, B3,.....
Dataset C, with values C1, C2, C3,.....
Dataset D, with values D1, D2, D3,.....

What I need to do is 'merge' them all together to create a 4 column list
with each possible combination.

i.e.

A1,B1,C1,D1
A1,B2,C1,D2....
A1,B1,C2,D1
A1,B1,C2,D2.... etc

I may not have explained this very well and am not that good with VBA so any
help at all, appreciated please. Happy to try and explain further!
Many thanks

 
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
Create chart using part of data table (data legend) Koulla Charts and Charting in Excel 0 October 21st 09 08:17 AM
Create WB, create new Sht, paste data. (Macro not working) Rick S. Excel Programming 6 October 31st 07 05:33 PM
Use detailed data in one worksheet to create summary data as chart source rdemyan Charts and Charting in Excel 0 January 23rd 07 02:18 PM
create Macro €“ select data, sort by acc no., yr, part no, create P Johnny Excel Programming 0 November 22nd 06 03:18 PM
create macro to move label type data to column data JonathonWood9 Excel Programming 4 February 21st 05 10:53 PM


All times are GMT +1. The time now is 09:51 PM.

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"