LinkBack URL
About LinkBacks
I have been trying to fix the below code but didn't work. Not sure why the pasterange isnt working.trying to copy data from one place to another and then loop. somehow the below code isnt going through.
Please Login or Register to view this content.
I have been trying to fix the below code but didn't work. Not sure why the pasterange isnt working.trying to copy data from one place to another and then loop. somehow the below code isnt going through.
Please Login or Register to view this content.
Last edited by chikki985; 05-02-2018 at 10:24 PM.
Could you be so kind and put your code between code tags.
Thanks for pointing out. Actually cells BH1:BM1 is a formula based on pivot. Whenever the date changes in the pivot , BH1:BM1 gets updated and then each time, it should be copied to EB3:EG3.For example, When date is 04/30, BH1:BM1 is copied as values to EB3:EG3. for the next run , when date is 05/01, same cells BH1:BM1 is copied to EB4:EG4 and so on .
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Date Source . Destination
04/30 Cells (BH1:BM1) Cells (EB3:EG3)
05/01 Cells (BH1:BM1) Cells (EB4:EG4)
05/01 Cells (BH1:BM1) Cells (EB5:EG5)
This is the logic i am trying to create.
hi please find some advice below and the solution in bottom
Problem
1. Name need not closed by ",
orPlease Login or Register to view this content.
2. avoid use select and selection in second line. can changePlease Login or Register to view this content.
toPlease Login or Register to view this content.
solution for question,Please Login or Register to view this content.
Change
toPlease Login or Register to view this content.
changePlease Login or Register to view this content.
to offset commandPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by BoredWorker; 05-02-2018 at 11:22 PM.
Hope you can learn every time you visit here.
If you still confuse on how it work, kindly ask or go to
i) Formula - Formula (Ribbon) > Formula Auditing (Section) > Evaluate Formula > Evaluate; or
ii) VBA/Code - Click F8 to see how it work step by step.
It it take care of your question, Please:
Mark tread as [Solved] [Thread Tools->Mark thread as Solved];and
Click *Add Reputation to thank anyone solved your question.
Thank You. Looping works fine but it still has small problem. I need the below but somehow the latest value in cells BH1:BM1 is copied to EB3:EG4 instead of EB4:EG4.
Date Source Destination
04/30 Cells (BH1:BM1) Cells (EB3:EG3)
05/01 Cells (BH1:BM1) Cells (EB4:EG4)
it due to your code is stated it copy EB3:EG4
change toPlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks Boredworker. Should I add any loop condition as the second line should be added to "EB4:EG4"?
nope,
as the offset is cover that portion,
you just need to put the offset command in the loop.
*if you can please try to use F8 to see how the code work line by line.
**attach the sample excel file as well, as it easy to test the code. (*remember to remove sensitive data)
Below is the final code i am using but still has some issues.
Please Login or Register to view this content.
if can please put an example file to let us to test as well instead of just putting code here.
with code only we cannot have test as we do not know what result you needed.
i think should put the offset in to the loop.
Change toPlease Login or Register to view this content.
Please Login or Register to view this content.
I have attached the sample data. Please take a look. I am still getting the error.
Hi chikki985,
The error is cause by the offset function.
should be add "Set" in front.
I change your code abit, use of "With" made the structure more tidy.
below line is add to faster the process, if you want to see how it work line by line, please delete this line.
Please Login or Register to view this content.Please Login or Register to view this content.
Awesome Boredworker. You are a pro!!It works splendidly.Thank You so much . If I need to edit the code in such a way so that it automatically selects each date from the pivot in decending order and paste the data as you did in the above code . How can we do this?
Actually all the step is same as what you give, just the structure is change (just let it look nicer).If I need to edit the code in such a way so that it automatically selects each date from the pivot in decending order and paste the data as you did in the above code . How can we do this?
except this one: (Add "Set" in front), this is the reason why previous code cann't work.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks