Thread: Macro/VBA help - lots of xls imports
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve M[_7_] Steve M[_7_] is offline
external usenet poster
  
Posts: 1
Default Macro/VBA help - lots of xls imports

I have 3 spreadsheets A, B and C

A & B contain information in the exact same format

With C I have 2 columns that compare their values against each other
and highlight any differences(through a small VBA script)

I want 2 buttons in C spreadsheet that:

Button 1: Offers the user to open a spreadsheet(A - name can vary) then
copies A2:A500 of that spreadsheet to spreadsheet C(A2:A500)

Button 2: Offers the user to open a spreadsheet(B - name can vary) then
copies B2:B500 of that spreadsheet to spreadsheet C(B2:B500)

Any ideas if this is possible


--
Steve M
------------------------------------------------------------------------
Steve M's Profile: http://www.excelforum.com/member.php...o&userid=32520
View this thread: http://www.excelforum.com/showthread...hreadid=523047

Reply With QuoteReply With Quote