Hello all,
In the attached spreadsheet (Only looking at 'Report' and 'Data' tabs. I have various dropdown boxes for users to use to select the criteria for their report. I need to pull certain fields from the 'data' sheet based on the criteria given. I wouldn't even be sure how to go about this. Could someone point me in the right direction?
I also need the criteria to be ignored if the boxes are left empty. so empty = all.
CAPEX Dropdown : column V in 'Data' sheet
Capitalised? Dropdown: This needs to pull the data based on column 'A' in 'data' sheet. YES = anything with values in column A, NO = Anything with blank in column A, (Blank) = all.
Period From & To Dropdown: Column C in 'data' sheet. blank should be all.
If too complicated, just setting me on the right path for what macros I should be using would help. I can do some jigging myself.
Regards,
James
Bookmarks