Automate some of my daily Activity in Excel using Excel Macros

Closed
Report
Posts
1
Registration date
Wednesday September 30, 2015
Status
Member
Last seen
September 30, 2015
-
 Blocked Profile -
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

1 reply


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
I mean I am new to this VB Scripting
Thanks for providing quick start to my research.

Thanks and Regards,
Sri
Blocked Profile
Not a problem, do you need an address to send the check to? You are being paid, right?