Search results

Also if next cell without indent then Sr. No 2- No indent 2.1 - 1 indent 2.1.1 - 2 indent

Sr. No shd start from 1 1 No indent 1.1 - 1 indent 1.1.1 - 2 indent 1.2 - 1 indent 1.2.1 - 2 indent And continued based on Indent

Hope clear,,,

Hope it is clear now....Please avoid Macros (as restricted)

It should start with 1..

Column A - S.no Column B - Description with indent So based on Column B indent, Column A s.no to come automatically once I put s.no as 1 in cell 1 of column A

In rows of particular column

Any Help? S. No means Serial number

Please suggest any formula to automate Sr. Nos. with indenting in subsequent rows as below: 1. 1.1 1.1.1 2. 2.1 2.1.2

Marc, Just by copying your program in Post#18 and pasting in binary excel file will give me the result. Just clarifying in case i am doing some mistake. Thanks

Understood Marcs, But the data is given to me by my vendors as as dump. Now i am struggling it analyze the data. Hence requested the help from all the persons here. Let us see if some solution. Thanks Again!

As per post#16, the data is getting summarized but as you are aware that the layout is different in all sheets the same data is not getting captured

Marc, As per your Post#18, 1) i have saved "Summary" file in .xlsb (Binary format) 2) Copied the code in your post#18 3) Pasted in "Visual basic" in "Summary" tab 4) Changed path - Inserted the folder name --- P = Source.Path & "\" 5) Ran the macro Data came as required but only for...

Thanks Marc. I have such 200 workbooks (none of them with same layout) received from vendor. Now i have to summarize the data (selected one) for in the "Summary" layout. Hence needed the help. Thanks again.

Mark, Please tell how should i use the program (Should i copy paste the program in excel sheet) and keep it in same folder where files are kept. Followed by "Run".

The red highlighted in summary book are the required/expected results. Just incorporated manually for demonstration purpose. Thanks

By mistake i forget to delete Summary from sheet 2. Please ignore summary of File 2 (in new sheets sent to you i have deleted it)

The data which i have incorporated in Summary is from file 1 and file 2 but it is done manually by me. I need help for the automation of the same means the data in "summary" file should be update automatically from various files under the headers (in colors) and date wise from file 1 and 2...

Hello sir, Any update.

Ignore "tab 2" in the "sheet 2"

Thanks for the response. The data which i have incorporated in Summary is from file 1 and file 2 but it is done manually by me. I need help for the automation of the same means the data in "summary" file should be update automatically from various files under the headers (in colors) and date...