I asked a question earlier, but I managed to put an image.
I will send it again.
Now we are creating a time management table, there are books that each person in charge enters in the shared file and accounting books with items added to the same layout in the accounting file.
[Input] is this layout and there is no cell X column.
There is a book for each person in the shared file, each with a password. When each person in charge completes the input, the manager/department of the department in charge opens each book, checks the check box after confirmation, and the day is over.
At the moment, accounting has pasted each book as a link copy.
I want to transfer the input data to the relevant part of the book in the accounting file when the manager check box of each book is checked, but I do not know how to do it well.
I tried to do macro recording, but I got error '91', and I couldn't even figure out how to deal with it.
1. Files are separate.
2. The accounting file is closed.
3. The book has a password.
Thank you for teaching us under the above conditions.
Answer # 1
I'm sorry for everything.
Even though I was a VBA beginner, I suddenly tried to make something with multiple conditions.
I want to practice and learn from something that is relatively simple.
The current link copy will be supported for a while.
Thanks for being too reliant in the situation where no one in the company knows about VBA.
- i want to switch the vba specified range cells vertically and horizontally
- i want to embed a checkbox in a specified range of cells with vba
- vba - post specified value to specific cell range
- convert excel vba cells to range
- vba error handling "" range "method failed:" _global "object"
- [vba] extract data of another sheet multiple times
- i want to create an if statement with "perl" time range specified
- vba: cannot copy and paste to another sheet in the same workbook
- vba - speed up when moving old data to another sheet
- vba - i want to set up a macro that saves to the specified folder only the files that contain arbitrary character strings among
- i want to make cells visible/invisible using excel vba
- java - i want to make all the cells of the specified column of jtable a combo box
- vba - i want to copy the results filtered by the filter to the cells of another sheet, one cell at a time
- vba - i want to list the search results in another subform
- vba - i want to update only blank cells
- vba - i want to select a sheet and copy the contents to another sheet
- how to refer the value of another sheet with vba form
- to find values from a range with excel vba
- i want to reference a value from another book with vba and replace a specific string
- vba - chrome i want to get the elements of the page opened in another window
- python 3x - typeerror: 'method' object is not subscriptable
- python - you may need to restart the kernel to use updated packages error
- xcode - pod install [!] no `podfile 'found in the project directory
- vuejs - [vuetify] unable to locate target [data-app] i want to unit test to avoid warning
- android studio - emulator: dsound: could not initialize about the error message directsoundcapture
- android studio - unresolved reference comes out in kotlin
- mysql startup failed [error] innodb: the innodb_system data file 'ibdata1' must be writable
- django - oserror: [winerror 123] the file name, directory name, or volume label syntax is incorrect : '<frozen importlib_boot
- python - importerror: cannot import name md5 error cannot be resolved