Simple query, but is there a simple answer?

RET79

Well-known Member
Joined
Mar 19, 2002
Messages
526
Hi,

I have a macro, that is designed to extract chosen values from one worksheet, and put them on a row together on another worksheet. I have set up a simple input spreadsheet, where I would like the user to specify which cells he/she would like to extract the values for.


I want it so that an user could just enter B4, B5, B6 etc. in one column on the input sheet(ie the range would need to be dynamic) and then the macro would extract the values from those cells specified, then put them on one row(with no gaps between them) on another new worksheet.

Hope this makes sense,

RET79
This message was edited by RET79 on 2002-03-26 11:06
 
Thanks for all your help. I will certainly look into userforms.

However, I have managed to do this task by manipulating dynamic arrays, the dynamic array being the list the user creates using the cell references. If anyone is interested I could show you how I did it, it's pretty snazzy.
 
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,213,536
Messages
6,114,210
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top