VBA how to create new worksheet and move value
Solved/Closed
yogi_himalayan
Posts
2
Registration date
Tuesday March 12, 2013
Status
Member
Last seen
March 13, 2013
-
Mar 12, 2013 at 05:30 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2013 at 07:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2013 at 07:55 AM
Related:
- VBA how to create new worksheet and move value
- Create skype account with gmail - Guide
- Create new instagram account without phone number - Guide
- Vba case like - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Create snapchat account - Guide
2 responses
yogi_himalayan
Posts
2
Registration date
Tuesday March 12, 2013
Status
Member
Last seen
March 13, 2013
1
Mar 13, 2013 at 12:02 AM
Mar 13, 2013 at 12:02 AM
Thanks Trowa, for your advice. But I am looking for VBA code.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 12, 2013 at 12:16 PM
Mar 12, 2013 at 12:16 PM
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
Mar 16, 2013 at 12:18 PM
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
Mar 16, 2013 at 07:47 PM
Mar 17, 2013 at 07:55 AM