ronald54457874
New Member
- Joined
- Sep 26, 2021
- Messages
- 17
- Office Version
- 2013
Hello guys, my first post here haha, I hope you all invited well.?
Here's the thing I have a spreadsheet in which it registers values that are contained in cell A2, that is, it takes the value in that cell and creates a new spreadsheet and renames it using the name of cell A2. Understood so far right? So he took the name of cell A2, created the sheets and renamed it.
but what I ended up seeing is that it's complicated to make a condition...
If (Search all spreadsheets for cell A2 value to see if you already have a spreadsheets created with cell A2 name)
Found spreadsheet with that name?;
add in the last blank line new values copied previously, as this part is just a piece of code.
If you didn't find it (Create a new spreadsheet named cell A2)
As you can see I don't know how to program IF in vba, I'm pretty new.
I can paste the values to be filled in the lines where there is nothing. But I can't get the cell name on all the other sheets.
If you have doubts I'll post something else, I didn't find the need to create an example plan, if necessary I create and play here lol.
I just finished my Example sheets, I believe what I now need an example is to download and read the comments in the VBA I created.
Thanks
Here's the thing I have a spreadsheet in which it registers values that are contained in cell A2, that is, it takes the value in that cell and creates a new spreadsheet and renames it using the name of cell A2. Understood so far right? So he took the name of cell A2, created the sheets and renamed it.
but what I ended up seeing is that it's complicated to make a condition...
If (Search all spreadsheets for cell A2 value to see if you already have a spreadsheets created with cell A2 name)
Found spreadsheet with that name?;
add in the last blank line new values copied previously, as this part is just a piece of code.
If you didn't find it (Create a new spreadsheet named cell A2)
As you can see I don't know how to program IF in vba, I'm pretty new.
I can paste the values to be filled in the lines where there is nothing. But I can't get the cell name on all the other sheets.
If you have doubts I'll post something else, I didn't find the need to create an example plan, if necessary I create and play here lol.
I just finished my Example sheets, I believe what I now need an example is to download and read the comments in the VBA I created.
Dropbox - File Deleted - Simplify your life
www.dropbox.com
Thanks