Hello,
I'm new to macros and need some help. I am trying to create a macro that copies cells B2 and C6 from the active worksheet in a workbook called "transfer". Then searches for the first empty cell in a worksheet called "summary" in a workbook called "report" and pastes the value from B2 in the first empty cell in column D and the value from C6 in the first empty call in column E. Any help is very much appreciated.
Hi Iwayl,
Welcome to the Forum!
Try this:
Directions for running the routine(s) just supplied
Please Login or Register to view this content.
Copy the code to the clipboard
Open your Workbook
Save your Workbook or Another Workbook designated for Macros as Macro_Enabled
Press ALT + F11 to open the Visual Basic Editor.
Select “Module” from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks for the welcome! I tried the code and it works if there are no values in columns D and E, but it does not seem to find the next empty cell and add paste the values to those columns if there are already values in some of those columns. I am using Excel 2010. Am I doing something wrong?
Hi Iwayl,
Try this - if it doesn't work, I'll need to see sample spreadsheets:
Please Login or Register to view this content.
Last edited by xladept; 05-10-2014 at 06:47 PM.
I guess it worked. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks