A
alexm999
I currently have a spread sheet which I manually input data into on a
daily basis. I'd like automate this aspect.
I have a computer program that runs a report every night for 5
different computers. The report outputs a Text file depending on the
date the report has run (i.e. 1.txt would be january 1st, 2.txt would
be january 2nd and so on).
I put together a spreadsheet which is has 5 worksheets and is ready to
accept data from these text files. Here are my questions and where I
need help:
1) I only 6 cells populated in each worksheet
2) on the next day, i'll need data to be put on the next row so it wont
delete the day before data
3) i'd like to have a button that if i press it (i.e. Update) it will
update the 6 cells in each worksheet.
Help would be greatly appreciated...
daily basis. I'd like automate this aspect.
I have a computer program that runs a report every night for 5
different computers. The report outputs a Text file depending on the
date the report has run (i.e. 1.txt would be january 1st, 2.txt would
be january 2nd and so on).
I put together a spreadsheet which is has 5 worksheets and is ready to
accept data from these text files. Here are my questions and where I
need help:
1) I only 6 cells populated in each worksheet
2) on the next day, i'll need data to be put on the next row so it wont
delete the day before data
3) i'd like to have a button that if i press it (i.e. Update) it will
update the 6 cells in each worksheet.
Help would be greatly appreciated...