im using vba code to produce charts on a seperate sheet when a company name is selected from the first sheet. Only everytime i do this, the data of one company is deleted. When i retype the data back into the sheet and save it and try running the code again a different company's data is deleted. Any explanation?
I can post all my cod eif it helps
I can post all my cod eif it helps