
How can I paste the date and time from another workbook and …
Aug 22, 2024 · How can I paste the date and time from another workbook and prevent excel from changing the date to 1/0/1900? This is the data I'm copying from a spreadsheet I received.
Can you combine multiple open Excel files into one Workbook?
Sep 24, 2012 · I need to place multiple excel files into one workbook. Is there a way to do this easily without having to copy & paste each one individually and placing them into one …
Automatically update a cell in a workbook based on the value of a …
Apr 2, 2015 · And so on. I'm trying to do this for a workbook with multiple worksheets of monthly values for mutual funds I own and another workbook (single worksheet) that shows asset …
Excel undo stack mash-up - Microsoft Community
Jun 23, 2025 · How do undo an action only in my current spreadsheet? Undo from single workbook only, with multiple workbooks open Undo when several files are open in Excel 2010 …
subscript out of range error 9 change name of worksheet
Jan 28, 2015 · You can try the following. If the workbook is open then Save and close it. Close Excel. Backup your workbook as follows. Create a new folder in windows explorer While still in …
Application.OnKey - refers to another workbook - Microsoft …
Feb 25, 2013 · I have to have 3 or 4 workbooks open at the same time with the same (named) macros in them. To make them work I use the WorkbookActivate event to assign keys to …
Last Modified date per sheet in NON macro enabled shared …
Feb 17, 2018 · BR BrandyTurner1 Created on February 17, 2018 Last Modified date per sheet in NON macro enabled shared workbook
Dropbox Files as Source Data for Excel Pivot Tables
Mar 30, 2016 · I have an Excel workbook (Workbook 1) that contains pivot tables that use data from a different workbook (Workbook 2). Both workbooks are shared with colleagues on Dropbox.
Filtering Issue - Microsoft Excel Online - Microsoft Community
Sep 4, 2021 · I will send a private message to collect the workbook. You can save the workbook to your computer and then upload it in the private message or create a duplicate workbook in …
Hyperlink a cell within workbook - Microsoft Community
Mar 6, 2020 · The free Excel workbook "Professional_Compare" (updated) is available at MediaFire. (compares every cell in two worksheets Or each row in one worksheet against all …