検索
検索

Copying data from a file and changing the target every day using a date input

debugcn 投稿 Dev
2
Matheus Danella

I have been inputing data in an Excel file everyday using a bunch of other Excel files. But now, I would like to start doing this automatically.

The first thing that I did was to create a code that would input the data that I need, but I have to change it every day because the day changes as well:

='C:\destination\[Archive2016-08-18.xlsx]Sheet1'!A1

I am having problems to edit this code to change the date "2016-08-18" from my input in those three other cells that I put the numbers on. Also, everyday it would fill the line below it, creating then a list of values as the days passes. I am also having troubles for doing it.

This does not look hard, but I am having lots of trouble while doing it.

Thank you.

atclaus

Edited
Add a helper column in Column B that is =text(A1,"yyyy-mm-dd")
Then this formula in C1 =INDIRECT("'[archive"&B1&".xlsx]Sheet1'!A1",TRUE) assuming you have the date in cell A1. For some reason you cannot nest the text inside the indirect

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0
サインイン

関連記事

分類Dev

copying file of remote source to remote target folder

分類Dev

How to find a file matching a specific pattern and date while copying every found file to another web server's directory?

分類Dev

Copying a file from a shared folder to a remote machine using PowerShell

分類Dev

Changing position of data in Input file to a .cpp program Changes output unexpectedly

分類Dev

Copying data from one table to another using php mysqli fails

分類Dev

Copying data from file into a specific location of another file with dd truncates the output file

分類Dev

Cross-copying DATE atributes of a file in PowerShell

分類Dev

AccessViolationException after copying a file from inside a zip archive to the clipboard and handling its data

分類Dev

Copying and modifying a file to incorporate additional data

分類Dev

Reading data from an input file and placing the data in appropriate fields in an xml

分類Dev

Make my mongoDB collect data at a certain time of day every day?

分類Dev

How to print values from an input data file from an array?

分類Dev

Using CRUD repository in spring Data JPA, date return by findById(long id) methos is day-1 Date of Date stored in Database

分類Dev

Copying words from one file to another in cpp

分類Dev

Issue on copying file from internal storage to sdcard

分類Dev

Copying text from file to specified Excel column

分類Dev

Changing data file directories Cassandra

分類Dev

Repeat event on assigned day every week until specific date

分類Dev

Azure Function Input Binding from CosmosDB: Will data loading occur on every call?

分類Dev

Copying files across hard discs while keeping the original file date?

分類Dev

AJAX - How to get data from input file to append formdata?

分類Dev

AJAX - How to get data from input file to append formdata?

分類Dev

Force CMake to generate configure_file target every build

分類Dev

Changing data from long to matrix

分類Dev

Best way to compare date from source to target

分類Dev

Copying row info from one sheet to another, based on cell input

分類Dev

Get file names from specific input using Java Servlet 3.0

分類Dev

Using Spring Batch to parse date from file into LocalDateTime

分類Dev

Using Spring Batch to parse date from file into LocalDateTime

Related 関連記事

  1. 1

    copying file of remote source to remote target folder

  2. 2

    How to find a file matching a specific pattern and date while copying every found file to another web server's directory?

  3. 3

    Copying a file from a shared folder to a remote machine using PowerShell

  4. 4

    Changing position of data in Input file to a .cpp program Changes output unexpectedly

  5. 5

    Copying data from one table to another using php mysqli fails

  6. 6

    Copying data from file into a specific location of another file with dd truncates the output file

  7. 7

    Cross-copying DATE atributes of a file in PowerShell

  8. 8

    AccessViolationException after copying a file from inside a zip archive to the clipboard and handling its data

  9. 9

    Copying and modifying a file to incorporate additional data

  10. 10

    Reading data from an input file and placing the data in appropriate fields in an xml

  11. 11

    Make my mongoDB collect data at a certain time of day every day?

  12. 12

    How to print values from an input data file from an array?

  13. 13

    Using CRUD repository in spring Data JPA, date return by findById(long id) methos is day-1 Date of Date stored in Database

  14. 14

    Copying words from one file to another in cpp

  15. 15

    Issue on copying file from internal storage to sdcard

  16. 16

    Copying text from file to specified Excel column

  17. 17

    Changing data file directories Cassandra

  18. 18

    Repeat event on assigned day every week until specific date

  19. 19

    Azure Function Input Binding from CosmosDB: Will data loading occur on every call?

  20. 20

    Copying files across hard discs while keeping the original file date?

  21. 21

    AJAX - How to get data from input file to append formdata?

  22. 22

    AJAX - How to get data from input file to append formdata?

  23. 23

    Force CMake to generate configure_file target every build

  24. 24

    Changing data from long to matrix

  25. 25

    Best way to compare date from source to target

  26. 26

    Copying row info from one sheet to another, based on cell input

  27. 27

    Get file names from specific input using Java Servlet 3.0

  28. 28

    Using Spring Batch to parse date from file into LocalDateTime

  29. 29

    Using Spring Batch to parse date from file into LocalDateTime

ホットタグ

アーカイブ