MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Dynamic cell range

  Asked By: Richard    Date: Feb 02    Category: MS Office    Views: 912

I am new to excel.I have a problem which is explained below.

I have 2 excel sheets sheet1 and sheet 2.
sheet2 contains entry as follows

col1 col2 col3
12 15 17

col1 col2 col3 col4 col5
00 34 23 3 1
56 3 21 45 31

my sheet1 will have a list containing name1 and name2.if i select
name1 in sheet1,i want the rows below name1 to be fetched from
sheet2 and copied into sheet1.Since there can be many rows in sheet2
it is not possible to know the range(it is dynamic).

Also in sheet1 i have to get many rows.so there also the range of
cells where these rows should be pasted will keep on changing.these
rows from sheet2 need to be pasted one after another.

Can somebody help me to solve this problem?



1 Answer Found

Answer #1    Answered By: Feodora Bonkob     Answered On: Feb 02

Im not sure if I understood your problem  well , but a simple way to have a
dynamic range  is to use the code

Range(Inputbox("please define the range")) so you can define different range
each time

Didn't find what you were looking for? Find more on Dynamic cell range Or get search suggestion and latest updates.