**Excel Formula needs to add Index to return cell information** *Summary*: Hello, Currently I am working with two tabs of data that do not have the same unique identifiers at the same time. I am using a series of functions ...

**[Solved] Count continous cells with data. Insert automatically row.** *Summary*: HI .. i have a Data for entry.. in which i have data in this order Name (ALpabetic) Street (Alpha Numeric) Adress (Alpha Numeric) Telephone (Numeric) ...

**List the firs n line of a txt file in batch** *Summary*: I known that there is a loot of answers about this problem but i just cant find the solution. I always get some error. The real problem is i have to d...

**how to separate data into sheets with X rows** *Summary*: Dear all, I am quite new into macros in Excel and I would like to ask you to help me to solve this problem. I have a .xls file with almost 40.000 row...

**Copy Paste 1 - 18 Row To A New Worksheet** *Summary*: Hi everyone i am stuck with this problem, i have 40 lines in my excel spreadsheet..how can i do a macro that it will copy and p...

**[Solved] How to sort rows randomly in Microsoft Excel?** *Summary*: I have a table sorted from A - Z, I need is to sort it in random values, ie, without following any criteria, for example, A, H, J, A, K, L, S, O , R, ...

**insert rows based on cell value** *Summary*: To anyone that can help, I am trying to find a way to insert a number of rows based on what value is in the cell in column AF. So if "1" is the value...

**Delete empty rows in columns in Word** *Summary*: I am merging documents from a database and in the document are many tables with rows and columns. In the end there are many tables that have empty row...