work sheet

Hello. I am having issues with an Excel Workbook that I created. On a few of the pages the "Fill Color" is not appearing. However on some of the previous pages, the "Fill Color" is appearing. I have tried to correct the current pages by selecting a cell and click the fill button on the...

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...

Hello everybody, I have different tables and workbooks. In Sheet1 of every workbook i have a table that vary in the amount of columns. From this table I have to make a Sheet per column. In each Sheet the cells have to always be column 1 and then the corresponding column. For example: Table1...

Hi everyone, I'm looking to automate the process of repeating an excel worksheet (which is set up with various tables and formulas) for various countries. I have a referenced list of countries set up in worksheet 1. So for example: in worksheet 2 I have a sheet set up for Albania - and I want to...

Hello, Just a quick (and I'm sure, easy) question regarding SUMIF across worksheets. Basically I have written my SUMIF to work perfectly on my first worksheet which is fine. However, instead of the output being on the first worksheet (same worksheet as SUMIF), I would like the output to be...

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?

Hi, I have 125 work sheets in one workbook and it contains data about companies for 8 years i.e. 2003 to 2010. Sheet 1 which I called "index" contains the Name of companies in one column and their abbreviation (sybmol) in other. All the 123 sheets are named as per these abbreviations. Now if...

I'm not looking for anyone to do the work for me; I want to be pointed in the right direction. I want to create an Excel spread sheet for logging call information when our main tracking system is down. It doesn't need to be sophisticated. I want to create a work sheet with input fields...