Previous Topic Next Topic

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
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
Related:

1 response

Answer 1 / 1
Blocked Profile
Sep 30, 2015 at 05:03 PM
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
Sri
Oct 7, 2015 at 06:25 PM
I mean I am new to this VB Scripting
Thanks for providing quick start to my research.

Thanks and Regards,
Sri
Blocked Profile
Oct 7, 2015 at 06:31 PM
Not a problem, do you need an address to send the check to? You are being paid, right?

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses