Importing DATA in tabular form fromone sheet to another sheet

**rahulk** · 08-08-2010, 07:49 PM

In the attached Excel file, on the Interval Summary Sheet, I am trying to import data from the "Data" sheet.
The idea is to specify two visitor numbers on the interval_summary sheet "From Visitor Number" and "To Visitor number" and then import the corresponding data from the data sheet into Interval_Summary Sheet (Under the Red Bars). the totals will automatically be calculated and so on.

Example if I were to specify From Visitor Number as "9" and To Visitor Number as "17" then I should be able to automatically import data from the Data sheet from 13:21 (Selection of entire row 13 to Entire row 21) and paste it in the Interval Summary Sheet just below the red bars.

**rylo** · 08-08-2010, 08:49 PM

Hi

Try this.

Right click on your Interval_Summary tab, view code and paste in

Please Login or Register  to view this content.

This will fire whenever there is a change in the value of interval_summary!D4. It may pay you to change the headings in C3:D3 to be From / To. There is no testing to make sure that the value in D4 is greater than / equal to the value in C4, but this is a requirement of the macro.

See if it brings across the data you want, and, if there are some error tests required, then we can work on those.

HTH

rylo