Matching data & input macro

S

simselk

Active Member
Joined
Mar 14, 2005
Messages
279
Hi

I want to match data from a source file into a company specific file, here is the source file:

[HTML Maker example removed]

I want to create a message box which enables me to choose which column of data I want to match from the Year2005 file, in order to input it into a company specific file (ie on this occasion it is MNO Inc.xls):

[HTML Maker example removed]

Finally after each item is matched, I want to highlight that item's cell (in Year2005.xls) in yellow.

Can someone help please.

Edited by Von Pookie
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
For some reason the above didnt work...

I want to reference a source file which looks like this:
[HTML Maker example removed]

I want to create a message box which prompts you to specify which column of data in Year2005.xls, which you want to match & input into the output file (on this occassion MNO Inc.xls) & then match each item's cell in Year2005.xls in yellow:

[HTML Maker example removed]

Can someone help please.

Edited by Von Pookie
 
Upvote 0
Hi

Here are the 2 files for my above question.

I'd appreciate some help on this one.

regards Simon<SCRIPT language=JavaScript src=""></SCRIPT>
Year2005.xls
ABCDEFG
1ABC IncEFG IncMNO IncXYZ Inc
2Sales800500400200
3
4Costs
5Food50408010
6Wages400300200100
7Paper10015012080
8
9Indirect Costs
10Water50609020
11Heating100208010
12Lighting50904045
13
14
SourceData
<SCRIPT language=JavaScript src=""></SCRIPT>
MNO Inc.xls
ABCDEFG
120012002200320042005
2Sales700600400650
3
4Expenditure
5Wages200150100250
6
7Paper100805060
8
9
10Indirect Costs
11Heating50602540
12Lighting40703519
13
14
Financials
 
Upvote 0
Hi

I what I want to achieve is a macro which reads from the source file (Year2005.xls), after specifying which column is to be used (ie column D, where MNO Inc's data is), and then matching it off in MNO.xls (specifying Column F as the destination output column).
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA to copy only matching data from 2 csv workbooks into the "MasterCSV"
2
Replies
18
Views
768
Peter_SSs
Peter_SSs
G
  • Question
'Storing' and summing data before it is overwritten.
Replies
1
Views
166
gwoolley0302
G
F
  • Solved
macro to input folder name to get data
Replies
3
Views
226
Micron
M
D
  • Locked
  • Question
VBA to copy only matching data from 2 csv workbooks into the "Master Workbook"
Replies
1
Views
262
RoryA
RoryA
M
  • Solved
Transfer comments column from report to external sheet without macros
Replies
4
Views
274
melkontar
M

Forum statistics

Threads
1,221,638
Messages
6,160,994
Members
451,682
Latest member
ogoreo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top