Create A Sheet And Add Data To Spreadsheets Within A Folder

[Dazzawm]

I have a spreadsheet with data in columns A and B. Is is possible to create a sheet (called data) within these files (all various names .xlsm) on each spreadsheet within a folder on my desktop and add the data to that sheet? Thanks.

 

[Dazzawm]

Solved.

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[Dazzawm]

I just didn't want people to waste time working on it.

 

[Fluff]

Now that you have said it's solved, they probably wont spend any time on it.