tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I want to be able to copy data back and forth using two macros that can transpose the info,
so the first one is Grid to Line
With this one i want to copy Sheet"New" Range ("I11:R27")
to Sheet"Data" find first empty row in column D and paste it. as one row so transpose it every 10 columns so i end up with one row of data,
the second might be more tricky,
what i need is for the macro to find the row with the data in it buy using the data in Sheet New,cell D5
then copy the row columns P:GD transposing every 10 columns
please help if you can
thanks
Tony
I want to be able to copy data back and forth using two macros that can transpose the info,
so the first one is Grid to Line
With this one i want to copy Sheet"New" Range ("I11:R27")
to Sheet"Data" find first empty row in column D and paste it. as one row so transpose it every 10 columns so i end up with one row of data,
the second might be more tricky,
what i need is for the macro to find the row with the data in it buy using the data in Sheet New,cell D5
then copy the row columns P:GD transposing every 10 columns
please help if you can
thanks
Tony