LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Delete Row If-- Data aggregation issue

Hi,

I have this data:

column A B C D

timestamp bs bp as ap
00:07.0
00:07.0 30 2402 9 2403
00:07.0
00:07.0 29 2402
00:07.0
00:07.0 8 2403
00:07.0
00:07.0 19 2402
00:07.0
00:07.0 17 2403 30 2404

What I want to do is have a macro that can combine the data so that it
moves all the values so that I have an order book that looks liek this

timestamp bs bp as ap
00:07.0 30 2402 9 2403
00:07.0 29 2402 8 2403
00:07.0 19 2402 30 2404
00:07.0 17 2403

I do not know VBA but I want to learn, so if you are kind enough to
post the code I will make the effort to dissect it to understand how
it works.

I have given a name to the columns
A is TIME
B is BS
C is BP
D is AS
E is AP

Thank you
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data aggregation with multiple workbooks Kadco Excel Discussion (Misc queries) 1 May 10th 10 10:19 PM
Data aggregation with multiple workbooks Kadco Setting up and Configuration of Excel 0 May 3rd 10 09:54 PM
Data Aggregation Question... Trevor Williams Excel Programming 2 August 26th 08 01:57 PM
Aggregation... Ted Buoy Excel Discussion (Misc queries) 2 June 11th 07 08:15 PM
pie charts with aggregation [email protected] Charts and Charting in Excel 1 July 16th 06 11:53 AM


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"