A program has to be written, from my experience you would need to use selenium + java or python, another option is nightwatch. (of course there are others also) Or you can use a website that offers to automate tasks. Excel's Paste command is a familiar tool for most Excel users. The image below depats a typical payroll calculation. To duplicate this section of the worksheet for a new week, you would click on cell A1, press Ctrl-A to copy the contiguous cells and press Ctrl-C to copy the data.
Aug 29, 2018 · Open the VBA Editor by pressing Alt+F11 on your keyboard. To put the code in a module: Right click on Project1 and choose Insert > Module Copy and paste the macro into the new module.
Select the initial table that needs to be copied, and press Ctrl+C. Select the new (already copied) table, where you need to apply the column width format, and right-click on a cell. Find the line «Paste Special» (CTRL+ALT+V) in the drop-down menu. In the dialog window, select the option «Column widths», and click «ОК».