Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! importing data from other worksheets...
Atg the moment, i am using vlookup's and if's, sumif's etc to get info from
one spreadsheet to another and adding it up. Is there any way i can make a macro to be able to drop in a file and have it source the info from it automatically? I am analysing timesheets and with vlookup's, i need to keep changing the file names for where to look for the data. if i can't do the first, can i make formulae that will look for a file that i only have to change one cell for? I hope you understand what i mean! i'm not sure i do! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Can you combine data from 2 worksheets into 1 chart? | Charts and Charting in Excel | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions |