Hi gurus,
I wonder if you could help & guide me - so basically I'm creating a sales management tracker for 15 products and it will be updated week by week. I want that every time I change the week from dropdown than it brings that week up on the screen from Column E to AB with data underneath - even if it's blank for data entry.
I'm not sure what logic will work here - as i'm still an amateur to excel and vba world, but i have read your post and you guys are amazing.
It may be the column copy over to new area and blank it show up - not sure. Column T:W is hidden and has sum formula in it so don't want that wiping off.
Any advise would be much appreciated.
Thank you
I wonder if you could help & guide me - so basically I'm creating a sales management tracker for 15 products and it will be updated week by week. I want that every time I change the week from dropdown than it brings that week up on the screen from Column E to AB with data underneath - even if it's blank for data entry.
I'm not sure what logic will work here - as i'm still an amateur to excel and vba world, but i have read your post and you guys are amazing.
It may be the column copy over to new area and blank it show up - not sure. Column T:W is hidden and has sum formula in it so don't want that wiping off.
Any advise would be much appreciated.
Thank you