book

The printing company I work for is running into a lot of manual entry on excel to figure out shipping weights for freight and customer cost. A quick example would be: Book Quantity = 150 Book Weight (per unit) = .75lbs A carton for the books weighs 1lb each. A carton can fit a finite amount...

There are books that teaches preparing Journal entries in Excel I am looking for a book that teaches about Excel sheets like these Is there a book that teaches you to prepare account related Excel sheets like the above ? Thanks

Hello, I have tried to get this question answered before but to no avail, so I am trying again. I have been struggling to make a macro that will simplify my workload. Simply put, the macro works between two workbooks, one that is opened in XLSTART and the actual book that is being worked on...

So I have multiple workbooks in SharePoint, the regions data, that I want to conglomerate in a HQ book. The regions workbooks are secured so that each region can only open their workbook but I have permissions to open all of them. The columns are all the same across each regions book. I want to...

I have a range of dates that are written as, for example, 20190102 I am trying to format it to show as 1/2/19 and im not having any luck. I've tried the format cells/date and its not changing. Ive copied and pasted the 20190102 into another work book as a value and tried to format it and had...

Dear Expert, Actually i have a excel work book of 160 sheet and i want to insert a new row within the work book. Is it possible to can we do in a single command ? Kindly help.. Thank you all !

Hi, I have a excel log book for booking resources with multiple worksheets for each month of the year. Each worksheet has the same templates (same headers). Like Column A-D is for Book A, E-H is for Book B...etc and Column A, E will record the user name, Column B, F will record the contact...

how do i hyper link to a named range in another work book? i have: ='4. multi excel 4.xlsm'!totalnegative but it doesnt work

Hello I have a master workbook template that many people use for a request form, as soon as they press SEND the origional form is kept on there local drive as a blank form. However the sent file is saved on a network location with its own unique workbook name, My question is that on the...

Hello, I need to consolidate a lot of spreadsheets in one book. All have the same format and fields. I need something that it could be sure and not lost my information.

Is it possible for a workbook to automatically take all the sheets in that workbook and copy then to another sheet every time the book opens? So as I add new sheets to the book and re-open it the recap sheet would have all the data on it already?

Hi I've got multiple macros that I want to run in order with one button press. Is it as simple as just copying all in one new macro? I also then need to <colgroup><col></colgroup><tbody> combine macros create new book named xx remove formulas from certain columns on each sheet save...

Hello all. Thank you in advance for any help I will try and explain and I hope someone can help. I have a book called book 1. I would like some VBA in book 1 which will vlookup column A in a closed workbook called Book 2 returning column g of book 2 in column g of book 1. The only problem is...

I have an invoice called (Invoice). I would like a script to get the invoice number, customer number and each line item, including Quantity and Amount for each item. I would like to get this information into another sheet in my workbook called (Invoice List 2).I have found some scripts online...

Hi all, The Excel 2016 In Depth book mentions registering the book with QuePublishing to receive the downloads for the book; I did this. However, the message I get still says: "Code samples are available for this book. Register your book to get access to all the samples and worksheets." Despite...

Hi, I have two workbooks. I am looking to copy an Image from the closed book (Image Source) and paste it into the open book (Source Portfolio.xlsm). The Images are signatures and have been named to correspond with the staff names stored in ComboBox1 ie. J Bloggs would have a signature image...

Hi I need to write code which loops and deletes rows in a workbook (let's call it Book 2), if the name of a row in column A in Book 2 is the same as the name of cell B4 in Book 1. Please find below some sample data. For Book 1, the name in cell B4 is "Coffee" in this example (but it could...

Hi there, I realise it has been asked before but I could not wrap my head around how to average out letters for a marks book. My spreadsheet is for athletics and each grade cell is reliant on an IF function eg. =IF(C2<15,"A",IF(C2<17,"B",IF(C2<21,"C",IF(C2>21,"D")))). I am hoping that I can...

I would like to copy the data from a work book that I know is open, however i do not know the full name of the workbook I do know the work book name will be in the format mm RED1234567 ddmmyy.xls and the sheet name will beRED1234567 Using just this RED indicator is it possible to copy the...

I have a work book that has remained unchanged in excel 2013 for years. I have moved to Office 365 and now every time the book opens I get an error and the excel book is repaired. I then have to save as. Rename the file back to the original name and then reopen it without the error. However...