Excelina1234
New Member
- Joined
- Nov 10, 2014
- Messages
- 23
Hi All,
I'm going to try to explain this as best I can.
I've created an Excel spreadsheet, in which there is an Inputs tab. In order to keep the sheet tidy and organised, I have created a row at the top, where I can add the hardcoded information. The idea is that, upon pressing a button that is linked to a macro, this information is A) automatically fed into the relevant section in the input sheet and B) that the cells, into which I hardcoded the original data become empty (i.e. clean and ready for someone else to add their information, push the button, and so on).
For example:
I have veterinary data on different pets that were treated (cats or dogs). The top of the sheet will have the empty cells that I need to fill in with information (1. Category (Dog/Cat), 2. Name, 3. Age). Once I have entered the following information into the cells...
Category Name Age
Dog Stella 4
... I will push the button and the data is added to a list of all the other dogs that visited the clinic. If I add a cat's information, I want the information to flow into the cat directory. Both directories are on the same page, separated by a couple of empty rows.
Unfortunately I cannot upload any excel myself, but hopefully these instructions are clear enough. Just spent the entire morning trying to figure this out and *any* help will be much appreciated.
Many many thanks,
Claudia
I'm going to try to explain this as best I can.
I've created an Excel spreadsheet, in which there is an Inputs tab. In order to keep the sheet tidy and organised, I have created a row at the top, where I can add the hardcoded information. The idea is that, upon pressing a button that is linked to a macro, this information is A) automatically fed into the relevant section in the input sheet and B) that the cells, into which I hardcoded the original data become empty (i.e. clean and ready for someone else to add their information, push the button, and so on).
For example:
I have veterinary data on different pets that were treated (cats or dogs). The top of the sheet will have the empty cells that I need to fill in with information (1. Category (Dog/Cat), 2. Name, 3. Age). Once I have entered the following information into the cells...
Category Name Age
Dog Stella 4
... I will push the button and the data is added to a list of all the other dogs that visited the clinic. If I add a cat's information, I want the information to flow into the cat directory. Both directories are on the same page, separated by a couple of empty rows.
Unfortunately I cannot upload any excel myself, but hopefully these instructions are clear enough. Just spent the entire morning trying to figure this out and *any* help will be much appreciated.
Many many thanks,
Claudia