Search results

Awesome. Works beautifully

Sorry my mistake. Seems i didnt copy the full code. :(

Awesome code. :) it does the job. But we lost the save functionality. Now all excels are open with data and it doesnt save it in the location. :(

Remaining Documents (created using macro).

After changing the 1 to 2. The macro didnt paste the data in the new workbooks. Uploading the document.

i know the issue, the code that has been provided uses 1st column as unique value filter. But what if my 2nd column or 3rd column is the unique value which needs auto filter. I would like to thank you very much for this amazing code. One small thing in this code will make it great for me.

If the column of the Unique value changes, where do i update the code. I made one column change and the code failed. Can you help.

I apologize for the same. I am uploading the excel workbook.

Error: AlphaNumericOnly gives the error of Sub, Function, or Property not defined

Expected is: WB1: Master Workbook having WS1, WS2 and WS3 (no splits) WB2: Sheets WS1, WS2 and WS3 having data for only Resource 1 WB3: Sheets WS1, WS2 and WS3 having data for only Resource 2 WB4: Sheets WS1, WS2 and WS3 having data for only Resource 3 Till the last Resource available in WB1.

OK thanks. I tried running the macro, what it did was took the active sheet and split it via the column selected. but it doesnt do anything for the other worksheets. What the macro should do is: 1. Active sheet split into multiple workbooks based on the selected columns 2. goto sheet 2 of the...

Hi I have 2 worksheets: Sheet 1 and Sheet 2. Sheet 1 is the Master Db having Application Id, Environment Name, Milestones, Start Date and End Date. Each Application Id can have multiple environment and multiple milestones. Looks like this Application Id Environment Name Milestones Start Date...

The VBA should make multiple workbooks having same worksheets filtered by App Id.

File

Good news... The code split one worksheet into multiple workbooks. But the requirement is to have all worksheets split based on a single column in each worksheet

The code didnt split. It asked me for the column for filter but didnt do anything beyond that. What could have been possibly wrong.

I have a workbook called "WB1.xlsx" which has multiple worksheets "WS1", "WS2" and "WS3". Each worksheet has a common column called "Name".... I am looking for a macro to split the data using the Name column into multiple workbooks. The output should look like: WB1: Master Workbook having...

Because my second table is static and needs further updates from stakeholders. Hence, keeping it with pivot and some table with open fields seems tough in pivots. Array has degraded the performance and keeps re-calculating the whole table (3000 rows) everytime sometime updates one date in the...

Thanks Vivek. Understand that you have used the Pivot and Min within the same for SDate and EDate... But how about a formula to calculate the same?

Hi I have 2 worksheets: Sheet 1 and Sheet 2. Sheet 1 is the Master Db having Application Id, Environment Name, Milestones, Start Date and End Date. Each Application Id can have multiple environment and multiple milestones. Looks like this Application Id Environment Name Milestones...

Thanks a lot for your help :)

i mean single cell. like a,c,e.......

Thanks. But need that values in single row than multiple rows seperated by comma. As we dont know how many columns would be there

Hi I am attaching the sample file. Columns and Rows can be "n" numbers. The macro should pick the column A and paste it in the resultant table And then each row based on the value "x" available it should put the column headers spaced by comma. The columns could be infinite and rows could be...

I have uploaded the sample file.