book

Do anyone know if there is a similar personal macro book in microsoft word, where it is possible to store default macros?

Dear Mr. Jury, Please help me for storing all worksheets from Workbooks into One Excell Book. Thanks and Regards, DINAUKAUR

Hi what I am trying to do is. I want to leave my excel book open and outlook open. Everynight if possible I want to run this macro below paste it to a new email with email address example: JOhnl.com; and send it a like 3:45 AM eastern time. Then close the book dfgdrg.xlsx possible? Sub...

Saving personal macro book in VB Editor by: Select "File" then "Save" Personal.XLSB. However when going to the folder for the personal macro book: C:\Users\jjohn\AppData\Roaming\Microsoft\Excel\XLSTART The saving date of the personal macro book has not been updated to todays date. I some...

Hi My sheet name is 2018, i want to save my work sheet as new work book with name 2018 in csv extention. Kindly help

___________BOOK 1___________________BOOK 2 These 2 workbooks are linked. The function in Book 2 column C2 (Decisions) is =IF([Book1]Sheet1!C2="Declined",C2,""). I am looking for a function / VBA code to delete the blank/unmatched rows of Book 2 or modify the formula of C2 to skip cells that...

Hello, I recently purchased The 54 Greatest Excel Tips of All Time and I am needing the files that go with it. I can't seem to locate them with the information from the book. I appreciate the help.

Is it possible to use a macro to refresh data in the active workbook (book 1) from a table of data in another workbook (book 2) which will also need refreshing from a third workbook (book 3)? that is, cause book 2 to refresh when the the data in book 1 is refreshed? I am trying to get around...

Thought this would give me the last row in another worksheet of my work book,It does not. Please - why not? LR = Sheet("Pob").Cells(sht.Rows.Count, "D").End(xlUp).Row

If I copy a formula from the worksheet 'List' in one workbook to the same named worksheet in another, say: =sumif('Data'!$b$4:$b$44,'List'!$b4,'Data'!$c$4:$c$44) It automatically inserts links to the old workbook: =sumif('[Old book .xlsx]Data'!$b$4:$b$44,'[Old book .xlsx]List'!$b4,'[Old book...

Hi there. I have a "live" online spreadsheet on our company intranet (shared with clients) I have a parent workbook (with dashboards) that needs a second workbook (with calculations) to open in order to update all graphs. My code is: [VBA] Private Sub Workbook_Open() MsgBox ("For up to date...

hi, been trying to get some vb that will combine multiple workbooks that are located in various folders/locations into one master work book & hope mr excel can sort? many thanks in advance KR Trevor3007

Hello world, I am stacked here with a challenge and I need your help pull me out: I have a column that contains list of items so I need a script that looks for a specific item in that column say "Book" and when found, clear data for the row that contains the item "book". I am just...

Been inactive for years and just logged back in using my 2004 Password! Looking for some assistance on this sheet my wife sent this morning. Should be easy for you guys on this board. Pretty sure it can be accomplished with those hairy INDEX/MATCH functions but they are Greek to me! We need...

Good afternoon all! What I am trying to achieve is this: - User opens Workbook A - User clicks a button to open Workbook B so they can edit it (B is password protected, it can only be opened in write mode from book A; this is supposed to 'force' users to only use book A (and its userforms) to...

I am in the process of creating a scheduling spreadsheet for a small manufacture. We are scheduling machines, not people. I am just about complete, having everything but the following working well: When scheduling 2 jobs that use the same machine and need to be done at the same time, it will...

Hey Guys quick one (hopefully ;)). I have a cell that contains multiple text entries. I would like to find dates within that cell. I've partially solved it however I can only find the first date. For example: currently the formula I have finds the first date by search for the word review...

Thank you in advance for taking the time to read this and possibly help out. I need to find a way to find many different numbers across 4 columns (in another book) around 19K cells in each column and replace those numbers with different numbers, for example. Book1...

Hi all, I know there has to be an easier more efficient way to do this... In column B I have random numbers, sorted into "books" of 10. I'm looking to sort each of the "books" ascending, but each book by itself. I recorded some code, but REALLY don't want to have to hardcode and edit each...

I can not remember the "name" of this feature to look it up in the book. I've got a bunch of gas receipts that I'm auditing and I want to highlight purchases on weekends and outside of work hours. What formula can i use to quickly highlight these kinds of purchases? I'm having a hard time...