book2

Hi, I have twoexcel documents, "Book1" and "Book2". Book1 is exportedfrom our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today Ihave to manually put in the data from Book1 to Book2. I want to automate thatprocess. In Book2 Ihave...

Hi all I've been looking on this forum, but can’t seem to find exactly what i'mlooking for... So, my question: Say you have a number of workbooks: Book1, Book2, Bookxx and Overview I need to extract data from Book1 and Book2 (and the others) into Overview. Now, I know a formula for Overview...

Hello I have a question. I have a worksheet in a workbook called "book2". In the worksheet "book2" the cell D14 takes the sum of those numbers above it and displays the sum in cell D14. My question is if I want to reference the of cell D14 in the worksheet "Book1" how would I do that? Thank...

Hi Everyone - I use this often to replace data on my sheet: <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Private Sub Update_EstDelv1() Dim lr As Long, I As Long Dim x As Variant lr = Range("A1").End(xlDown).Row For I = 1 To lr x =...

I need some help, i have been scouring for an answer on this one and i have hit a wall. Here is my question, buckle up and hopes i can explain it right. I have 2 work books. One contains job titles that come from a database in its own format - Call it book1. The second workbook has my master...

I was in an Excel document and opened the same document in the screen (reduced the screen and added a second window in the document). Basically opened the document showing a different tab in the document. I changed a cell in the newly opened document tab and apparently saved the new document...

Hi all, After some help if possible? Am using Excel 2016 I have 2 Excel workbooks saved in the same SharePoint folder (Book1 & Book2). Book1 contains a data set on Sheet1 (cols A to P) - the most up to date version of the data. This will be a fresh export that has been saved to the...

Hi all, I am sadly using office 2010 I have two SEPRATE workbooks (Book1 and Book2) Both workbooks have a similar filter for postcode(zip code for the USA) I want to select a Postcode within book 1's filter and have that also apply to the filter within book2. Any ideas? Thanks JC