Excel 2010-VB Macro formula into many spreadsheets
Solved/Closed
AnFey
Posts
1
Registration date
Monday February 24, 2014
Status
Member
Last seen
February 24, 2014
-
Feb 24, 2014 at 06:40 AM
AnFey - Mar 3, 2014 at 06:19 AM
AnFey - Mar 3, 2014 at 06:19 AM
Related:
- Excel 2010-VB Macro formula into many spreadsheets
- Microsoft office 2010 free download - Download - Office suites
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Pdf and xps add in 2010 - Download - Other
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 25, 2014 at 10:49 AM
Feb 25, 2014 at 10:49 AM
Hi Anfey,
It's not entirely clear to me what you want to do. But to cycle through a list you can use:
For each cell in Range("your range")
if "your criteria" then "copy row or cell to another sheet"
Next cell
Let me know where you get stuck.
Best regards,
Trowa
It's not entirely clear to me what you want to do. But to cycle through a list you can use:
For each cell in Range("your range")
if "your criteria" then "copy row or cell to another sheet"
Next cell
Let me know where you get stuck.
Best regards,
Trowa
Hello Trowa,
Thanks for your answer. Since the time I posted my question, I went through some tutorials to learn more about VBA and I have already done what you told me to do.
However, I did not manage to do everything I wanted to do. Let me explain. When I go through this list of cells (600 cells), I want to open a new spreadsheet for every cell and put the related data into this opened spreadsheet. What I have already done is that I opened "manually" 600 spreadsheets (by typing Maj+F11, 600 hundred times) and I run my VB code to fill the 600 spreadsheets.
Is there a way to open automatically the 600 sheets by using a VBA code? In other words, I am looking for a sample VBA code that opens a new spreadsheet automatically, I will adapt it with what I am doing.
Thanks a lot,
AnFey
Thanks for your answer. Since the time I posted my question, I went through some tutorials to learn more about VBA and I have already done what you told me to do.
However, I did not manage to do everything I wanted to do. Let me explain. When I go through this list of cells (600 cells), I want to open a new spreadsheet for every cell and put the related data into this opened spreadsheet. What I have already done is that I opened "manually" 600 spreadsheets (by typing Maj+F11, 600 hundred times) and I run my VB code to fill the 600 spreadsheets.
Is there a way to open automatically the 600 sheets by using a VBA code? In other words, I am looking for a sample VBA code that opens a new spreadsheet automatically, I will adapt it with what I am doing.
Thanks a lot,
AnFey
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 27, 2014 at 10:35 AM
Feb 27, 2014 at 10:35 AM
Hi AnFey,
If your sheets are already created use:
If they still need to be created then use:
Let me know if I can assist further.
Best regards,
Trowa
If your sheets are already created use:
For each cell in Range("your range")
Sheets(cell.Value).Activate
Next cell
If they still need to be created then use:
For Each cell In Range("your range")
Sheets.Add.Name = cell.Value
Next cell
Let me know if I can assist further.
Best regards,
Trowa
