Is there a way to copy a range of cells instead of using an Input Box. The cells I need are from A1 to E1 and then I know you could use xlDown from the E1cell. Here is my current code w/Input Box. I tried this but it didn't work: Set FromRange = Range(Cells(1, 1), Cells(44, 5)).Copy. The code I'm referring to is right after Workbooks(1).Activate
Thanks Ken Mc.
Please Login or Register to view this content.
Hi Ken
Lets ignore the above code for now and explain in detail what you would like to achieve. Attach a sample workbook with a required result highlighted.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Ok, I will do that in just a bit. Thank you Sintek.
Ok, here it is. On the "E" column, we will need to use xlDown because some districts have more stores than this one, and some fewer. Thank you
Do you need the other file I paste it to?
Please, I would like to assist but still have no idea what you are requiring
The code starts out from this file by clicking "Import This Week", it asks the user to open the file which is the first file I sent you. Then it asks the user to copy the columns from A1 to E1 and then down to the last store and then it pastes it into the InMoment file and then it deletes ever other row to get rid of duplication. Then it asks to open another file, but I don't need anything after that. That part is all good. Hope that explains it.
Hi Ken
i am very certain that there is a simpler way to do this. Must your code do the following:
1. Open the required workbook
2. Select the entire range A to E all available rows and paste it into your workbook
Such as...This code will select range A2 to LastRow of E
Please Login or Register to view this content.
@ sintek,
Hallo daar sintek,
This should actually read "to LastRow of A" wich will include all the data contained in Column E down to that specified LastRow. However, if Column E contains more Rows than Column A, your Code should be:This code will select range A2 to LastRow of E
Dankie jy.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
@ Winon
Aha...hallo daar Winon.
Lekker om van jou te hoor....Was wondering if you were going to find my error....Testing testing
Ha ha just kidding. Thanks for the assist...I'm come a long way lol...getting there slowly but surely
Ok Sintek and Winon , that worked perfectly. I sincerely appreciate the help with this. Both of you guys are gems!
Ken Mc
Ken...Play around with this...Much simpler
Please Login or Register to view this content.
Last edited by sintek; 03-29-2017 at 02:11 PM.
@ sintek,
Hi sintek,
Na watter Workbook verwys jy, om die kode in te gebruik?
It is important to place the Code in the correct relevant Workbook.
Thank you for the feedback kwesmc1.
Does sintek's proposed solution work for you? I would very much like to assist where I can, whilst giving sintek the credit!
The code should go into he's Command button [IMPORT THIS WEEK] in Workbook named Inmoment-Period_Unit.xls
Works when tested.
@ sintek,
Thanks for the clarification, seems the OP got the gist of your response. Well done!
Beste Groete.
@ Winon
Wow, now I feel absolutely awesome....Rep points from one of my Forum Mentors....Dankie Skat. Beteken baie.
Thank you. On the 2nd part of the routine, there is one more input box on the InMoment file. Is it possible to do more or less the same thing you did for the first part of the code? All I need is to copy on the file from E2 down and then paste it in the Div 4 Report Card file. Both files are attached.
Please Login or Register to view this content.
Did either of you guys get my last post, or do I need to start a new one?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks