book

I can't quite figure out the formula for the following scenario - We are looking at counts and adjustments so we want to see positive and negative % differences. The problem is if the book quantity is 0 and the count quantity is 0 and the book quantity is 0 and the count quantity is anything...

Stuck again i'm afraid. User manually copies a complete work book, Then clicks a macro enabled button to paste the data into the current work book. Workbooks("Template.xlsm").Range("A1").Paste Destination:=Workbooks("Template.xlsm").Sheets("INVOICE").Range("A1") however it gives a subscript...

Hi, Is it possible to Save a copy of an active workbook to a specific folder as a CSV format file while using the dialog pop up? Also I have an issue where If I cancel then the active book name changes to False, can someone help please Here is what I have at the moment which changes the active...

Hello Folks, i am preparing the sales report of books. I want to filter a book name in column C and want to add the number of books sold. the result should be in next sheet column C book name and column D total sold quantity. Please see the example below. <tbody> C D Book A 1 Book B 3...

Is there any vba book I should read for beginners

How can I sort all worksheets in a work book alphabetically but specify one particular worksheet to be 1st and another last ?

Hi friends i want to learn vba programming for excel. can anyone guide me the best vba book. thank you.

hello, I have an excel book i created to track inventory. The book has a sheet with a list of users (A), their initials (B) and a password(C). I have placed multiple command buttons on certain sheets that each run a different macro. What i would like is a way for users to be able to log in and...

Hi, I am currently putting together a database with over 300 items which randomly have to be shipped out and then brought back. I am going to produce a qr code for each item so I can book out and then book in each item into the database. How can I set the database so that each scan of the code...

Hi All I have a huge data file (1000000 rows) that shows amongst other things: Customer Number, Name, Item and Value. Im wanting to reduce the data set by combining multiple rows that are for the same person and the same item. For example in the table below I would like to combine Joe Bloggs...

Hello! I need to open a protected book reading a BAT file, in a silent way, without messages or alerts. Perhaps including the pwd as a parameter in the command line but I couldn't find how to do it. Thanks in advance.

Hi all This is really foxing me and I'm hoping someone can help before I pull all my hair out! In 2013/2016 creating a new workbook will leave the focus on ThisWorkbook even though it is the ActiveWorkbook, and I cannot seem to get around it. The reason this is causing an issue is that in...

I currently use 15 different spreadsheets for my bank reconciliations. In each book are 12 tabs, one for each month: JAN 18 FEB 18 etc. At the beginning of a new year, I copy and paste the file and rename it for the new year. In each book, I replace the old year with the new and delete the...

I have a large spreadsheet with 12 sheets reflecting the twelve months of 2018 (each sheet a month). This Book was authored by a former employee. The cells that reference dates (12/1/2018) have a cell below them that shows the DOW (Saturday). What I need to do is copy the entire Book and...

I currently have about 100 companies that each have 2 excel files. Each quarter I need to take 1 tab from one book and insert it into the other book and save that entire book as a pdf. I tried doing a macro for some of this but what happens when I go to save the file is it replaces the...

Morning (or afternoon or evening), If someone could help this one it would really help me out. I have a Workbook which has a button 'Update' on a worksheet called "Front". Ideally when the 'Update' button is pressed I would like the user to be requested to input a password. If not correct they...

I have 7 sheets in a book named Monday, Tuesday and so on to Sunday. In cell A1 of each sheet displays the current day of the week. when I open the book I need a VBA to select the sheet based on the current day. Example If today is Saturday then sheet Saturday will be selected.

Hi all. I'm having a problem trying to code this correctly and i'm looking for some assistance. I'm looking for a user to input a book title along with a date, in order to automatically show the correct version they should be using. For example: <tbody> Search Criteria Book Date User Input...

Hello Everyone This is my question I have a excel book that I have created for like a master inventory list and as I download the inventory excel books from my vendors I wanted to know is there a way for my excel book to check the vendor's file and match the SKU for a product and then...

Hi. Got a question. Is there a way to create a VBA code, that constantly checks a specific folder, if a new workbook is created? For it to be easy to understand, lets pretende workbook1 is called 1.xlsm (which im using), then if i create a book called 2.xlsm inside that same folder, i want to...