Previous Topic Next Topic

Macro Help

Closed
madpaddler - Aug 28, 2009 at 03:47 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 28, 2009 at 10:53 PM
Hello,

I need help with a macro. Mine works ok ... but I'd like more userflexibility.

Let's say I have 4 .xls workbooks in a folder. I'd like to compile three cells worth of data from each folder into a new workbook. Specifically, I'd like the data to paste in a single row (row A of the new workbook) ...

Here's where I am having trouble, I can specify the source range [e.g. SourceRng:="AF2:AG2"], but I'd like the end user to be able to type this into a pop-up or select it. It works by modifying the source directly.

And how can I get it to paste left to right as opposed to down a column (down a column is pretty easy).

Thanks for the help,
MP

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 28, 2009 at 10:53 PM
quote
And how can I get it to paste left to right as opposed to down a column (down a column is pretty easy).
unquoe
use in the macro something linke this
pastespecial transpose:=true

see help "pastespecial in vba help ..
open vb editor (alt+F11) and click the help and type the word "pastespecial" and click search
0

Similar discussions

Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Excel make cell flash red
hugrl -
Rjc -

13 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses