INDIRECT() works on another file, but only if such file is opened. Don't think you keep opened all 150 files. An option could be to collect data from all files into the master sheet in another file by Power Query, and here you may sort, filter, whatever such master da...
So the Email Tool workbook should contain a worksheet named Pull. The contract workbook should also be open in Excel. It should be the active workbook when you run the macro, and it should contain a worksheet named Page One. If the name of the sheet might vary, but if you are sure th...
Re: Pulling data from multiple Excel Sheets to a Master I think I am looking at using Method #1. I don't care too much if Sales Associates can see what the others are doing, but some aspects of the sheet would be better off being kept private for the security of our clients....
[SOLVED] Need to copy data cells from one sheet to another based on unique identifier By unitedscentdom in forum Excel - New Users/Basics Replies: 9 Last Post: 02-24-2015, 10:51 AM Merging Rows on a Unique Identifier while Keeping Unique Data and Adding Values Together By CP...
Contacts & Calendar items are not server based for Imap accounts - or to put it another way - stored on the local machine only so you'll need to manually migrate those to your new machine. If you're not clear on how to do that - depends on what you're coming from and what you'...
I have an excel file where when I try to pull data from a cell from one sheet to another, I get a major stall. It only happens from one particular sheet to two particular sheets in that order….no other sheets have this delay. ...
I know I’m a little late to the party here, but Im trying to pull a date from a previous sheet and add it to the next sheet, while adding 7 days to the date. Is there a macro on how to do this? I’ve already found a Macro to pull information from a...
Transferring a thread from google sheet to excel and is not pulling the data Hey guys really need help with this and not able get a response,This formula is working in google sheets but will not work in excel for some reason =IFERROR(INDEX(Sheet3!A:A,...
I want to create an additional tab where I can generate a full week timetable for a teacher or a class but pulling the data from the 5 daily tabs (Im aware it will be slightly different lookup formula for each tab) but is there a way I can make find all the times CMC...
If you can keep the other workbooks open, you can use the INDIRECT function: =INDIRECT("[" & $A2 & "]SheetName'!C3") where SheetName is the name of the sheet you want to get data from. INDIRECT doesn't work with closed workbooks though....