Hey all, I’m fairly new to powershell and I’d really appreciate some help.
I have a ton of really simple csv files that I need to do the following with:
- paste a csv into a specific sheet (ex. sheet1) of an existing excel template (so sheet1, into B4)
- then, I need to copy a chunk of data in a different sheet
- and finally save the copied data to brand new excel sheet
I’ve figured out how to do step 3 but step 1 and 2 are throwing me off really badly - any help or direction would be great!
Thanks!