VBA how to create new worksheet and move value
Solved/Closed
yogi_himalayan
Posts
2
Registration date
Tuesday 12 March 2013
Status
Member
Last seen
13 March 2013
-
12 Mar 2013 à 05:30
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Mar 2013 à 07:55
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Mar 2013 à 07:55
Related:
- VBA how to create new worksheet and move value
- Create new sheet vba - Guide
- Vba find - Guide
- How to create viber group - Guide
- Create new skype account - Guide
- Vba case like - Guide
2 responses
yogi_himalayan
Posts
2
Registration date
Tuesday 12 March 2013
Status
Member
Last seen
13 March 2013
1
13 Mar 2013 à 00:02
13 Mar 2013 à 00:02
Thanks Trowa, for your advice. But I am looking for VBA code.
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
12 Mar 2013 à 12:16
12 Mar 2013 à 12:16
Hi Yogi,
1. do this manually.
2. Sort column I to get all data together, now cut/paste it to Recs sheet.
3. Place the formula in column B of Recs sheet. Just put the sheet name with an ! before the cell references as in Sheet1!L1.
4. I have no idea how to create email using excel. Sorry
Best regards,
Trowa
1. do this manually.
2. Sort column I to get all data together, now cut/paste it to Recs sheet.
3. Place the formula in column B of Recs sheet. Just put the sheet name with an ! before the cell references as in Sheet1!L1.
4. I have no idea how to create email using excel. Sorry
Best regards,
Trowa
16 Mar 2013 à 12:18
Do this
1. Start excel
2. Start macro recorder
3. open you CSV file
4. Sort column I to get all data together
5. Create a new worksheet and rename it 'RECS'
6. Copy from your sorted sheet paste it to Recs sheet.
7. Place the formula in column B of Recs sheet. Just put the sheet name with an ! before the cell references as in Sheet1!L1.
8 Stop macro recorder.
This gives you a good template of what you are trying to do. Paste your resulting macro here
16 Mar 2013 à 19:47
17 Mar 2013 à 07:55