work book

Hi all, I have a workbook Main.xlsx that references another workbook Source.xlsx using an IF(COUNTIF(....)) function in the Main.xlsx. When both workbooks are open, the formulas in the Main.xlsx workbook return values and everything works fine. But as soon as I close the Source.xlsx workbook...

I am working on project where i need to add multiple workbooks Sheet in to master excel file. For E.g 1.First Workbook name "Stats_CK" 2.Second Workbook name "Stats_AM". Output Should be : Master Excel File with Sheets like Stats_CK and second Tab Stats_AM. However i am getting an output...

Hi everyone, I'm having an issue with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial...

Hello all, I have a very large workbook that is broken down into results and data per floor. I would like to reference the data tab to pull into the results tab. There are 8 graphs that I need to populate from the data. It is on a weekly basis and the data cell I need is very fifth. Example...

MrExcel: He usado la sintaxis Workbook... para formar una columna de datos en el libro en que tengo la macro, usando los numeros que se encuentran en una celda fija de varios libros con nombres consecutivos. PAra hacerlo, he tenido que abrir a la vez los 32 libros de origen. Cómo puedo...

Hello so here is problem I have a masterworkbook(marcgoproject4.xlsm) it has five(5) sheets all has headers sheets name : sheet1=ADDITEM sheet2=ITEMLIST sheet3=RECEIVED sheet4=SHIPPED sheet5=STOCK now the problem is i also have a babyworkbook(in.xlsx) that gets updated regularly only has...

I have 2 workbooks WB1 & WB2 for input & output respectively & both kept opened. WB1: Range: A1:E1085476 Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 93px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH...

Hello, I have an Excel File where i have all my projects and a button so when i need to open a project i just click on the button to open it. but the problem is that when i already have that file open and i click on it again it doesn't let me open it without erasing the data i had worked on...

Hello, I have tried searching for this on other threads to no avail. I am trying to create a Macros where depending on the value of cell A2 (I have a data validation LIST type here), worksheet 1 or worksheet 2 will open. For example, if the value on worksheet 1 cell A2 = "Yes" then hide...

I would like to have one sheet in an Excel workbook(B) be tied to another workbook(A). Thus, whenever I make changes to Workbook A, the worksheet in Workbook B automatically updates with those changes. Is this possible in Excel 2010?

from an active workbook, I would like to open a new file "testfile" and copy two work sheets ("result1", "result2") into the new file and then close it and continue working in the active workbook. seems simple but i keep getting errors. Thanks for any help

i need a data entry form that adds records to another sheet <TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448><COLGROUP><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 5741" width=157><COL style="WIDTH: 218pt...