excel-2010

<tbody> own vofavorite I have been working in <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space...

Hello! this will be a tough one... :confused: So I have workbook1 (wbThis) and workbook2 (wbTarget) and in wbThis' sheet I have some cells which are filled. These cells have the format of: From A6 P2123: Begin procedure A7 P1234: Code A8 P4456-6: Document | | | | | | | V A27 It continues...

I need to write a script to save a worksheet with to a predetermined location and the save name is filled from values within the worksheet. I can get it to save in the proper location, but the file name returns a combination of FATPMetiFolderPath and FATPMetiPath...

Hi all, I am trying to copy an example from a textbook so that i can edit it for my own use and i have typed out the Macro they apparently used. i Have checked a few time and can't see the error but i keep getting a 'invalid control variable reference' error and can't get any further. I would...

Hi all, I need a formula to extract number from a string example:v12 from the above i need the number(can be more than two digits) which appears after the character v

Hi All, I am trying to match headers of different files and copy data.If the one of the header is not matched then a new column with the non matching header should be created and the column has to be copied Ex: file1.xlsx has AA BB CC as header file2.xlsx has AA BB DD EE as header...

Hi, I have a column of values of 6 digit numbers, formatted in the cells as numbers. These come from a formula so =LEFT(RIGHT(B:B,24),6) returns 327549 in column F. I would like to find out which of these numbers are also in column G in another sheet called ISA in the same workbook. There is...