fill cell

Hi! Wishing you all a Happy New Year! This new year- My goal for this year is to ask for help and to understand macros and formulas more but since my workbooks seem a little tedious. I wanted to reach out because I have this extensive workbook with multiple formulas but I'm sure there is a...

Hi All, I am looking for a code that will help me copy a workbook and fill it with information from another workbook. i already wrote a code that creates a copy, now i need a code that it will take information from the source workbook put them into the workbook i just copied, i hope i have...

Hoping someone can shed some light on this, I am looking for a macro that would fill all the red cells with the text at the top of their respected column i.e AWV, CPE, CCM etc. I have not yet found anything that can recognize each individual column, always fills red cells with the same text...

#Newbie Hi all I tried to write a sub or a function to populate a selected cell with the formular below: =SUBSTITUTE(LEFT(CELL("filename"), FIND("]", CELL("filename")) - 1), "[", "") But i fail. Used examples but no luck. Beware the formula works only with a saved workbook anyone?

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

Hey Guys , so this is the Second part of my Problem Kevatarvind , was really kind to show my how to insert multiple rows . http://www.mrexcel.com/forum/excel-questions/711805-how-insert-1-row-between-every-row-has-entry-excel.html But now i would like to populate these newly created rows...

I cannot figure out how to create a macro that when you hold down say the A button then click on a cell it would fill that cell to a desired color

Hi all, I'm facing a performance issue concerning tables and dynamic ranges. I'm not sure I can do what I want with basic Excel instructions WITHOUT macros... Let's say that in Sheet1 I have a BIG table (eg. 10000 rows) that periodically grows in size by new inserts. In Sheet2 I need to have an...