ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   MACRO for Matching Two List (https://www.excelbanter.com/excel-worksheet-functions/196027-macro-matching-two-list.html)

nrobinson

MACRO for Matching Two List
 
I would like to create a file of data that has quanties used from one time
period. Then, periodically take another file of the same items from another
time period and bump it up against the first one. I want to match the items
and put the usage quantities side by side. Then calculate a variance of the
change in quantities and sort from hi to lo. I know how to do the basics but
how to write a macro so that I take the new file and just do the bumping up
against automatically.
--
NLRHU91


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com