Automate some of my daily Activity in Excel using Excel Macros
Closed
ccmsri
Posts
1
Registration date
Wednesday September 30, 2015
Status
Member
Last seen
September 30, 2015
-
Sep 30, 2015 at 04:01 PM
Blocked Profile - Oct 7, 2015 at 06:31 PM
Blocked Profile - Oct 7, 2015 at 06:31 PM
Hello,
I am a Hyperion technology Person. Looking for Vbscript code/Excel Macro code to automate my daily job. Before Looking for help on this, I would like to know whether we can achieve this or not?
Please find details below and let me know is it okay to implement for automate?
1. I will open 3 Excels named A, B and Z
2. Excel A has 10 Sheets in it (Named A1, A2,...A10). Now go to work sheet A4, go to cell B70 and select data by pressing keys Ctrl + Shift + Down arrow + Right Arrow from Keyboard. Copy the selected portion to new Excel named Z.
3. Again in the same kind of process need to do with Excel B as well.
Note: All my 3 Excels are in different locations in D-drive.
Please let me know is there anyway we can automate it or not.
Thanks and Regards,
Sri
I am a Hyperion technology Person. Looking for Vbscript code/Excel Macro code to automate my daily job. Before Looking for help on this, I would like to know whether we can achieve this or not?
Please find details below and let me know is it okay to implement for automate?
1. I will open 3 Excels named A, B and Z
2. Excel A has 10 Sheets in it (Named A1, A2,...A10). Now go to work sheet A4, go to cell B70 and select data by pressing keys Ctrl + Shift + Down arrow + Right Arrow from Keyboard. Copy the selected portion to new Excel named Z.
3. Again in the same kind of process need to do with Excel B as well.
Note: All my 3 Excels are in different locations in D-drive.
Please let me know is there anyway we can automate it or not.
Thanks and Regards,
Sri
Related:
- Automate some of my daily Activity in Excel using Excel Macros
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Macros in excel download free - Download - Spreadsheets
1 response
What is a Hyperion Technology Person?
Try taking a look at this, and see if it helps.
https://ccm.net/forum/affich-843792-copying-data-from-workbook-to-workbook-using-button
Try taking a look at this, and see if it helps.
https://ccm.net/forum/affich-843792-copying-data-from-workbook-to-workbook-using-button
Oct 7, 2015 at 06:25 PM
Thanks for providing quick start to my research.
Thanks and Regards,
Sri
Oct 7, 2015 at 06:31 PM