Filter data with a cell value in VBA and Paste in another

iamronakjain

New Member
Joined
Mar 10, 2014
Messages
1
Hi,
I am new to VBA,

I was preparing a automating report macro, in which I have to is sort data by date oldest to newest then use a cell values from different sheet called "Entry" and then filter the column 6 in sheet "rawdata" with that value. Then I need to copy the filtered results from "rawdata" and open a sheets from same folder with cell values used from "Entry" sheet and paste the data in "datanew" sheet.

For eg:
In "Entry" sheet at B7:B9 as IM12345 at B7, IM23456 at B8 and IM34123 at B9
The "rawdata" sheet currently have A1:N6365 and I have to filter from F row.
Then select all filtered value and copy it and open a file with name 12345.xlsc and paste it in "datanew" sheet from blank columns and repeat the process for next cell value.

Can anyone help me with that???
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,226,735
Messages
6,192,733
Members
453,752
Latest member
Austin2222

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