If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter iamronakjain
Start date Mar 10, 2014
Tags

copy & paste using vba filter in vba paste in blank rows

iamronakjain

New Member

Mar 10, 2014

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???