book

I have a workbook 1 in which i have 14000 count of data .from A1 till M14000 I am looking for a macro code which will distribute 14000 count of data to multiple different workbooks. I have 50 different workbooks in the same folder name as book 1 , book 2 , book 3 and so on till book 50. 14000...

Hi friends... bothers me a lot when i open a excel book, for view and when close.... display me the window asking me if want save or not... Strange, if i dont do any change.... i am sure.. how to fix it? i want ask me if want save, only if i make changes.... thanks

Hello: I have decided to learn macros and I have bought book called “VBA & Macros for Microsoft Excel” Bill Jelen, Tracy Syrstad. This book is great, but I have tried to find out where to download the samples files to play with them, e.g the book is asking me to open file called INVOICE.TXT.I...

Hello, I would like to convert Column A and Column R's cells using a few rules. Conditions: Column A: Takes out the year (2017.2018,etc) Takes out the parenthesis and it's contents (197236, etc, this number can be random) Takes out the word 'Book' Adds 'show' to the end (if it doesn't already...

Dear All, I have query regarding copy-paste. Copying data from PDF and paste into my excel book. My excel book is macro enables, contains some code.. While performing Ctr+f option on Sheet, it is not finding the text, though it is available on sheet... Could anyone guide me on this please..

Hi, I'm trying to make a table comparing how many clients write books with those who host podcasts. One column has book titles, and each title is different (those who don't write books have a 0 entered). I'm planning to use a new column to convert each book title name to a value of 1 (I'd like...

Guys, any chance you could give me some pointers? I have copied the below formula from another work book, where it worked fine. However it keeps returning a #Div/0! error in my new work book...

Hi all, I am running a vba that copies from other workbooks and pastes into ThisWorkbook with offsets etc. There are 10 workbooks altogether and at the end of each run the vba is coded to return each workbook to "Sheet1". My problem is that the returning to Sheet1 works in 9 of the workbooks but...

I am new here so please bear with me. My career has taken me away from VBA and I am now very rusty. Every month we take 1 sheet from 3 different files and create specific project files. The sheets are renamed and the new project files are saved in a specific location. In plain English, Copy...

hello i have tried macro for,the following thing. "list of codes" is a one excel book contains 16subject codes. "data file" is another excel file..it has 25 columns of data students data.like name ,id number,colege name,doj ,dob,area ,subject code,,etc.,; "imp details" is a new book Here ...

Hi I need help. I have a work book that contains several sheets that include formals. These formals use data from the different sheets within the workbook. What I’m trying to do is in one sheet insert 3 new columns without it changing the column letters eg insert the 3 new columns after column...

I forgot password to unprotected shared work book

I've tried to use the following formula with out any success.=if($a5<>"",vlookup($a5,'master sheet'!$1:$1048576,2,"") The error shows it to be $1. I'm not sure why this has happened as I've used this formula in another work book.

Good afternoon, I have the following code: Sub copypasteworkbook() Dim x As Workbook Dim y As Workbook Dim vals as Variant '## Open both workbooks first: Set x = Workbooks.Open(" path to copying book ") Set y = Workbooks.Open(" path to destination book ") 'Store the value in a variable...

Hi Everyone, I wanted a common userform where in the User will enter the Worksheet name and Range for populating multicolumn (5 Columns) listbox and worksheet name for storing data after data entry. In my workbook every week two sheets will get added one with multicolumn listbox data another...

where can I download the book files for slaying excel dragons?

Hi all, Thank you in advance for any help! I have 2 workbooks. ‘Book 1’ and ‘Book 2’ What I need to do is compare the same 2 columns on each row but the rows aren’t I. The same order in each workbook. So So run through column A in Book 1 find that value in column A Book 2 then compare the...

Hi all I recently got the above book, by Ken Puls and Miguel Escobar, and have a problem with the first example file "Ch01-Delimited.csv", which I downloaded in the way described by the book (same problem occurs if I try the text file "Ch01-Delimited.txt" instead of the csv). I am new to Power...

Is use of filter horizontally possible? I want use filter vertical and horizontal in same excel book on different data. Is possible?