moroformat
New member
- Joined
- Jan 22, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I copy data to the sheet "3" in a daily basis so the row count vary every day
depending on the date range I need. I need only the data in the rows with green
headings from sheet "3" to go the corresponding headings in sheets "1" and "2"
with the following criteria:
I need all of the rows with green headings
from sheet "3" with the word criteria "Asset" from column "BJ" copyied to the
green section of sheet "1" after clicking a button called run in sheet "1".
I
also need all of the rows with green headings from sheet "3" with the word
"criteria "Stock" from column "BJ"copyied to the green section of sheet "2"
after clicking a button called run in sheet "2".
I need the macro to also
keep the two rows of space between the green and yellow sections in sheets "1"
and "2" regardless of how many data it is copyied to the green section. In other
words I would like it if the green section autosizes so that there is always a
2-row space between the green and yellow section after the data is pasted in
sheets "1" and "2".
Thank you for your time and I would really appreciate
some assistance with this Macro.
Attached is the excel
file.
Thanks,
moroformat
depending on the date range I need. I need only the data in the rows with green
headings from sheet "3" to go the corresponding headings in sheets "1" and "2"
with the following criteria:
I need all of the rows with green headings
from sheet "3" with the word criteria "Asset" from column "BJ" copyied to the
green section of sheet "1" after clicking a button called run in sheet "1".
I
also need all of the rows with green headings from sheet "3" with the word
"criteria "Stock" from column "BJ"copyied to the green section of sheet "2"
after clicking a button called run in sheet "2".
I need the macro to also
keep the two rows of space between the green and yellow sections in sheets "1"
and "2" regardless of how many data it is copyied to the green section. In other
words I would like it if the green section autosizes so that there is always a
2-row space between the green and yellow section after the data is pasted in
sheets "1" and "2".
Thank you for your time and I would really appreciate
some assistance with this Macro.
Attached is the excel
file.
Thanks,
moroformat