Importing Data/column from one worksheet into another (to create report)

[incredible1]

Hi all,

I am new to VBA and I am having trouble importing data into the WS I need to create a report.

There are two tabs, Data and Report

The Data tab looks like this:

1 PIM13021 Y 17785 PA
2 PIM13021 Y 9346 PA
3 PIM12235 Y 9346 PA
4 PIM13024 N 13061 PA
5 PIM13124 Y 2491 PA
6 PIM13024 Y 3604 PA
7 PIM13021 Y 10213 PA

I want to import the data to my report tab via macro (except for the column with Y/N) and automatically calculate tax based on the state rate. The data tab changes every month and can vary in rows. I want to import it into the report tab starting at row 6 (the report has headers). I feel this is a simple task but I am having trouble declaring variables and getting it to work, and am not finding explicit google explanations. Thank you

[Tinbendr]

Welcome to the board!

Can you provide a sample workbook with the sample data?

At every import, will the previous data be removed?