Greetings everyone, I have a question (as seen in the title), which is kind of a pickle. (Using Microsoft excel 2019, on Windows platform)
Basically, I have an Excel document filled with Tables. 50+ or something. The logic behind what I want to do is easy enough; I want to select specific tables, say 1, 6, 9, 27, 43 and within those tables there are columns and rows, (say Row 1 to 4 and Column 1 to 4) of which I'm only interested in the row range 2-3, for columns 3-4. Then I want those Row-values to be transposed, and copy-pasted nearby.
The logic is there, but the knowledge to do so unfortunately is not.
I tried something with Record Macro, but it unfortunately didn't work.
Any help would be greatly appreciated. Thank you!
Basically, I have an Excel document filled with Tables. 50+ or something. The logic behind what I want to do is easy enough; I want to select specific tables, say 1, 6, 9, 27, 43 and within those tables there are columns and rows, (say Row 1 to 4 and Column 1 to 4) of which I'm only interested in the row range 2-3, for columns 3-4. Then I want those Row-values to be transposed, and copy-pasted nearby.
The logic is there, but the knowledge to do so unfortunately is not.
I tried something with Record Macro, but it unfortunately didn't work.
Any help would be greatly appreciated. Thank you!
