LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
hi
is it poosible in VBA, to make A lot of Copy Form My File With Certian Name, for example
my wb have around 15 ws
and this wb for 22 Products, in master sheet when i select Product all analysis update direct for this product, what i want to do
thank you in advanced
is it poosible in VBA, to make A lot of Copy Form My File With Certian Name, for example
my wb have around 15 ws
and this wb for 22 Products, in master sheet when i select Product all analysis update direct for this product, what i want to do
- change all sheets to Value (copy - paste special value)
- important point- to save the file with this product , then REOPEN master file, then do same steps for second Product, until Produc 22
thank you in advanced