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: 1
Default Comparing Two Cells on Two Different Worksheets


Hi All,

I'm new to this board and new to VBA. If you could point me in th
right direction, it would be much appreciated.

I'm trying to compare two cells on two different worksheets and addin
values into a column on one of the sheets.

Data is set up as follows:

WS #1 Invoices
A1: Acct# B1: ShipToCode C1: InvoiceAmt

WS#2 Accounts
A1: Acct# B1: ShipToCode C1: NewSalesTotal

I'm trying to match Acct#/ShipToCode and then add the InvoiceAmt t
NewSalesTotal.

I'm good at cut/paste and modifying the code to my needs but am havin
problems finding something similar to this.

Thanks in advance,
Christin

--
weeshie7
-----------------------------------------------------------------------
weeshie73's Profile: http://www.excelforum.com/member.php...fo&userid=2479
View this thread: http://www.excelforum.com/showthread.php?threadid=38354

 
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
comparing from two worksheets Lorne Excel Discussion (Misc queries) 4 May 11th 08 06:19 PM
Comparing two worksheets Sasikiran Excel Discussion (Misc queries) 2 September 26th 07 04:46 PM
Comparing two different Worksheets senthilmca Excel Worksheet Functions 0 June 1st 06 06:36 AM
Comparing Two Worksheets for changes Jugglertwo Excel Discussion (Misc queries) 1 December 7th 05 08:56 PM
Comparing two worksheets Dennis Excel Programming 1 November 14th 03 08:08 PM


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