fgh

Hello, I have 100 GL accounts and each GL has the same list of projects, as example- six projects. I need to copy each GL account down for each project. Can you help to write a Macro to automate this process? <colgroup><col style="mso-width-source:userset;mso-width-alt:3876;width:80pt"...

Hi Guys, I will describe you my problem as far as I can. I need help with a macro which fill search for duplicates based on column D and IF THERE IS duplicated row, he will be always in next following row. Then all what we need to do is delete the duplicated rows, but add values from columns...

Cells will contain a number beginning with 2 - can be anywhere in the cell, and number ends when a space appears after it. Can I use a formula just to return the number? eg; ABC 2014999 DDD 2014999 EE FGH A 2014999 A R E In each case the result should be 2014999. Needs to be a formula...

<colgroup><col></colgroup><tbody> How to extract words upto specified word ("Co ", "Eng", "Construction", "(") by single formula (not by VBA)(not by array formula)? 　 i.e. 　 ABC DE Co Ltd FGH IJ KL Eng Co Ltd ABC Construction Ltd ABC (China) Co Ltd to ABC DE FGH IJ KL...