I only dabble in macros but am trying a slightly more sophisticated task where in one sheet I key in 12 mths numbers in 12 rows that relate to one row in another data sheet. I want to lookup and find that one specific row and then paste value transpose the 12 mths across 12 columns to the right.
I've scoured lots of vaguely similar threads in Google but not quite finding my solution - and completely bamboozled with logic/syntax to adapt.
Appreciate any help.
Cheers
Simon
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I'm not sure if I'm replying to the right person as I got logged out and now can't see the thread!
However, here's my sample file.
Thanks very much.
Simon
Try this:
How to install your new code
Please Login or Register to view this content.
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Wow! That worked a treat with the test file thanks. Yet in the syntax I don't see reference to 'transpose' yet it did it!!!!
My observation from reading numerous threads is that no matter how much I try and interpret solutions posted, I don't understand and perhaps never will. I'll just take the solution and run but would be good if I really understood the logic. I might need to do a VB course! :-)
I'll run it through the actual model I want it to run on and hope it all works once change relevant sheet names.
Thanks so much.
Simon
The transpose is in the paste special functionality of the code. This line of code with the Flag "True", indicates a transposition
Look at the link in my signature blockPlease Login or Register to view this content.
Learn VBA Video Tutorials.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks