Software and Programs Thread, Excel - (num1 to num2) to list from num1 to num2 in Software & Hardware , Games; First post, and yes, I did search but wasn't sure what to search by (I did try various searches but ...

Short Link: http://forum.egypt.com/enforum/showthread.php?t=30959

newbe · 19-02-2009, 07:50 PM

First post, and yes, I did search but wasn't sure what to search by (I did try various searches but to no avail). Suppose in Sheet1 I have these 2 cells: 33206 to 33208 33210 to 33214 Now what I need to do is to create a list on Sheet2 that...

First post, and yes, I did search but wasn't sure what to search by (I did try various searches but to no avail).

Suppose in Sheet1 I have these 2 cells:
33206 to 33208
33210 to 33214
Now what I need to do is to create a list on Sheet2 that takes Sheet1's cells as an input and outputs on column A:
33206
33207
33208
33210
33211
33212
33213
33214
Any ideas? I can do this manually by taking "33206 to 33208" and spreading it out horizontally then manually copy/pasting the cells transposed, but this is not feasible when I have like a hundred of these.

TIA!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Software and Programs Thread, Excel - (num1 to num2) to list from num1 to num2 in Software & Hardware , Games; First post, and yes, I did search but wasn't sure what to search by (I did try various searches but ... Short Link: http://forum.egypt.com/enforum/showthread.php?t=30959