Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Macro to lookup in a workbook and append it to a table

I am very new at VB and need to create a marco for excel

I have the following situation:
A workbook with an unknown number of sheets. The first sheet is my summary
table which has 2 columns and a variable number of rows. This table contains
item# in column 1 and column 2 is for amounts (this column is blank).
Sheet 2 onward has tables of varying sizes. Column 1 contains item # and 2
contains amounts. There a more columns but those are not important. Some rows
contain no item #.
The macro needs to:
Look through all sheets starting with second one find item # matching the
ones in the first sheet then copying over the amount to the first sheet next
to the matching number. It is unknown on which sheet which item numbers will
be present and the code needs to go through all the sheets. The tables are
unsorted and can not be sorted.
Can anyone help me with this?
Reply
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
How do I Append excel data to a Access database table in a excel macro? Pete[_24_] Excel Programming 1 November 2nd 05 06:40 PM
Append workbook into a "Master" workbook Barb Reinhardt Excel Discussion (Misc queries) 10 September 20th 05 10:41 PM
append data to other workbook Todd Excel Programming 2 June 30th 05 04:59 AM
Append Data to Table after Web Query OmaSteak Excel Programming 0 January 29th 04 05:45 PM
Append Data To Access Table Martin[_14_] Excel Programming 3 December 3rd 03 08:33 AM


All times are GMT +1. The time now is 11:52 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"