I was wondering if there was, and I bet there is, an easier and faster method for an issue I have when working with a certain kind of Excel sheets.
At my work, I’m working with 2 or 3 different and new sheets per day with an arbitrary number of rows but usually there are between 10.000 and 250.000 rows in each document. In each sheet I need to create a new colon which identify this specific document (this is for parsing it later as a CSV file). Right now I’m copying the number from top to bottom and with 250.000 rows this can be a rather time consuming task. I would really save my day if someone had a solution for how to deal with this in an easy and fast manner. It could be a Macro or a formula. I’ve tried different approaches but with no luck.