Import selected columns from sheet to sheet help

Hello friends,

I want to extract the selected column data from sheet ‘Access’ to sheet ‘Data.
There is a master data on sheet ‘Access’ from range ‘B8:Q3000’. This table has a data entry time to time which is not fixed in range. The range of entered data is changing time to time. The main table range is ‘B2:Q3000’. I don’t want to import all the data to the ‘Data’ sheet. At present there are about 500 entries which may increase day by day. The range of data entered is not fixed so I have a problem of giving cell range for pasting the formula on ‘Data’ sheet. Now only first entry is imported from the ‘Access’ sheet to ‘Data’ sheet because I’m unable to fix the paste range.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you in anticipation.

Thank you. Problem solved.

Thank you.