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