Search : in
By :

Macro for copying colums and transposing it

Last answer on Apr 2, 2009 3:28:40 am BST Mani, on Mar 31, 2009 8:03:09 am BST 
 Report this message to moderators

S.No. 1
Order No 0
Evaluation Date 0-Jan
Week 0
EIN 0
Agent Name 0
QA Name 0
1a 1
1b 1
2a 1
2b 1
2c 1
3a 1
3b 1
3c 1
4a 1
4b 1
4c 1
5a 1
5b 1
5c 1
5d 1
6a 1
7a 1
7b 1
7c 1
7d 1
8a 1
8b 1
9a 1
10a 1
11a 1
12a 1
13 a 1
13b 1
14a 1
15a 1
16a 1
16b 1
17a 1
18a 1
18 b 1
Total Score Achieved
Description 0
Feedback 0
Type 0
Region 0

These are the details in column B of a sheet and I want to transpose th above data in next sheet in row2 and onwards. i.e. when ever i click refreash .it adds new row in the next sheet after copying the data from the previoud data.

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Macro for copying colums and transposing it » in :
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

epsiman, on Mar 31, 2009 9:38:08 am BST
  • +1

Actually im pretty good in macros for excel but this one i don't think it's possible...

   
Reply to epsiman

2

 Mani, on Apr 2, 2009 3:28:40 am BST

Thanks for the prompt approach.

If I have to Copy column B (Sheet 1) and transpose and paste it in Sheet 2, row 2.The value copied in row 2 should save and next time if I click save the data in row 2 of sheet 2 should save and the cursor should move to the next blank row.

URGENT HELP REQUIRED....

Do have any macro for the same.

Specifications.

Sheet 1 Name: Host
Shhet 2 Name: DB

   
Reply to Mani
Ask your question Reply
They need your help