Multiple sheets data update in Summary sheet by transpose mode

[shyampanda]

Hi,
I have a file attached herewith where there are several sheets names as locations and one Summary sheet. In Summary sheet I have got data from across sheets and updated. Here I have stuck and not found the below solutions.
1. By updating getting 2 consecutive blank rows which should be deleted.
2. The date format will be changed and not updating as per mentioned formats in sheets.
3. If I will keep the Summary sheet as 1st sheet the data is not updating. This is just a sample file and I have to add number of branches after it and I need to keep the Summary sheet as my 1st sheet.

I have highlighted the issues in yellow colour in Summary sheet.

Thanks.

[jindon]

Try

Please Login or Register  to view this content.

[shyampanda]

Dear Jindon Sir,
The given code is working superb.
Can you help me out to provide a code if a group of records in Summary sheet and i want to place in multiple sheets and sheet name will be as per names mentioned in D column "Location ". Just opposite the action i.e. from one summary sheet to multiple sheets.
Sorry for asking again.
Thanks.

[jindon]

For the workbook uploaded.

Please Login or Register  to view this content.

[shyampanda]

Dear Jindon Sir,
Both the functions are working superb. Only i have got a issue in dates. For ex. in each date i got this type of format like, weekdays-month-date-year. Wednesday, March 01, 2017 to replace i need only March 01, 2017 like this. No need to display weekdays.

[jindon]

The code is just copy/paste the data, so change the cell format of the date cell in each worksheet as you want.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.