Macro on a pivot
Closed
ELEE679
TrowaD
- Posts
- 2
- Registration date
- Tuesday July 30, 2013
- Status
- Member
- Last seen
- July 31, 2013
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Macro on a pivot
- Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
- Macro copy and paste in next blank cell - Guide
- Macro to create new sheet and copy data - Forum - Excel
- Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
- Run macro automatically when cell value changes ✓ - Forum - Excel
4 replies
TrowaD
Jul 30, 2013 at 11:03 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Jul 30, 2013 at 11:03 AM
Hi,
I could help you more specifically if you posted a link to download your file (www.speedyshare.com or ge.tt or ...).
Please show how it is now and how you would like it to be.
Best regards,
Trowa
I could help you more specifically if you posted a link to download your file (www.speedyshare.com or ge.tt or ...).
Please show how it is now and how you would like it to be.
Best regards,
Trowa
TrowaD
Aug 1, 2013 at 10:22 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Aug 1, 2013 at 10:22 AM
Hi ELEE679,
Thanks for uploading your file, it made things a lot clearer.
Here is your code:
Best regards,
Trowa
Thanks for uploading your file, it made things a lot clearer.
Here is your code:
Sub Test() Dim mRow As Integer mRow = 0 Do mRow = mRow + 5 Range("A" & mRow).Copy Range("A" & mRow + 1).PasteSpecial Range("A" & mRow + 2).PasteSpecial Range("A" & mRow + 3).PasteSpecial Range("A" & mRow + 4).PasteSpecial Loop Until Range("A" & mRow).Value = vbNullString Application.CutCopyMode = False End Sub
Best regards,
Trowa
Hi Trowa
Apologies for the late reply.
I finally managed to get a chance at work to test this and unfortnately it doesnt work.
I don't know what could be wrong.
No macro error messages appear - it just doesn't copy any cell at all to begin with so it pastes nothing.
Not sure what could be wrong.
Regards
Apologies for the late reply.
I finally managed to get a chance at work to test this and unfortnately it doesnt work.
I don't know what could be wrong.
No macro error messages appear - it just doesn't copy any cell at all to begin with so it pastes nothing.
Not sure what could be wrong.
Regards
TrowaD
Aug 12, 2013 at 10:24 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Aug 12, 2013 at 10:24 AM
Hi ELEE679,
Maybe you put the code in the wrong place.
Here is your file with code implemented:
http://wikisend.com/download/424390/ELEE679 - Macro on Pivot.xls
Best regards,
Trowa
Maybe you put the code in the wrong place.
Here is your file with code implemented:
http://wikisend.com/download/424390/ELEE679 - Macro on Pivot.xls
Best regards,
Trowa
Jul 31, 2013 at 06:19 AM
Ive uploaded the template at the lnk below
http://speedy.sh/3WTDu/ELEE679.xlsx
Please let me know if you need anything else.
Thanks for the offer to help
Regards
ELEE679