Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 18th, 2011, 07:03 PM
Registered User
 
Join Date: Jul 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default using VB to sort and export data

I am new to using VB in excell Or in general ... and I have been tasked with a project to sort and export sorted data to create separate spread sheets using data from a large spread sheet

the sheet Columbs are
SKU
BU
Gender
Country
Factory
CategoryStyle
Article
Vendor
Allocation
Color
OTB Month 1
OTB Month 2
OTB Month 3
OTB Month 4
OTB Month 5
OTB Month 6
Ttl
Color (BIM)
Combined Color
Fix
Note1
Note2
Season introduced
Status

I need to sort the data by vendor article and color add up the totals for the OTB field by color .... Can any body help with this ... PLEASE

Troy
 
Old July 18th, 2011, 10:21 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Welcome to the world of VBA Troy!

There are many ways to pick-up VBA; a book, VBA language reference etc. You can chose what you like.

VBA has the option of recording a macro. You can start recording a macro and do the necessary changes in the workbook and Excel will write the code for you in VBE. This is one easy way to learn

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Export data to MS Excel in VB.NET DPARK0312 General .NET 1 December 9th, 2013 03:06 AM
Export Data Grid to Excel in VB.net Windows App alapativg VS.NET 2002/2003 0 September 2nd, 2006 02:28 AM
sort data flyfish Access 5 February 7th, 2005 02:51 AM
Bubble sort vb.net Brettvan1 VB.NET 2002/2003 Basics 1 September 30th, 2004 09:13 AM
trying to sort data in excel with vb.net deanna VB How-To 0 March 26th, 2004 04:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.