Home

Excel Macro Help

%3CLINGO-SUB%20id%3D%22lingo-sub-846312%22%20slang%3D%22en-US%22%3EExcel%20Macro%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846312%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20tell%20me%20how%20to%20bring%20in%20an%20excel%20sheet%20from%20a%20reference%20workbook%20in%20to%20my%20macro%3F%26nbsp%3B%20My%20raw%20data%20only%20contains%20part%20of%20the%20product%20data%20so%20I%20am%20currently%20manullay%20adding%20the%20missing%20data%20in%20my%20workbook%20so%20I%20can%20pivot%20the%20dat%20with%20information%20needed%20to%20process%20sales%20in%20SAP.%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3CP%3EMad%20%E2%98%BA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-846312%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MadFricker
Occasional Visitor

Hi,  

Can someone tell me how to bring in an excel sheet from a reference workbook in to my macro?  My raw data only contains part of the product data so I am currently manullay adding the missing data in my workbook so I can pivot the dat with information needed to process sales in SAP.

TIA

Mad ☺

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies