Jump to content

automating data processing


Recommended Posts

Anyone know how to automate excel functions?

Deleting rows, deleting columns, add column headers, merging sheets?

 

Or know a program that could do all this stuff that has been tested?

 

I have a campaign that the customer submits excel files with extra rows(rows that are combined together, arggghh) for it's internal review and has 2, 3, and more sheets sometimes that needed to be merged together. Also has multiple excel files that would have to have all this stuff done to it and then all the excel files would then be merged into one.

 

Not sure if a script could do this in text editor and then covert to a .bat file?

 

:eek:

Link to comment
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...