VBA how to create new worksheet and move value
Solved/Closed
yogi_himalayan
rizvisa1
- Posts
- 2
- Registration date
- Tuesday March 12, 2013
- Status
- Member
- Last seen
- March 13, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- VBA how to create new worksheet and move value
- Excel vba copy rows to another worksheet based on criteria ✓ - Forum - Excel
- Creating multiple worksheets from a template and a list of names ✓ - Forum - Excel
- Create & name worksheets from a list and copy data ✓ - Forum - Excel
- Need VBA code to create loops Please ✓ - Forum - Excel
- Create new worksheet & copy the based on date ✓ - Forum - Excel
2 replies
yogi_himalayan
Mar 13, 2013 at 12:02 AM
- Posts
- 2
- Registration date
- Tuesday March 12, 2013
- Status
- Member
- Last seen
- March 13, 2013
Mar 13, 2013 at 12:02 AM
Thanks Trowa, for your advice. But I am looking for VBA code.
TrowaD
Mar 12, 2013 at 12:16 PM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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