Split columns and filter with timeline

[Vijayarc]

Hi ninja team
Please help on below query
In my daily using Excel ,which as 1,75 k rows we have columns H ,AQ,BF with data, completed-24 Days, completed-6 Days, wip-9 days, Not completed-12 Days,
I want macro to slip into 2 columns like
H . | I | J. | AQ . | AR | AS
____________________________________________
Completed 24. | 0-30 | Completed 12 |0-30
WIP 45 | 30-60 | Not complete 62 |61-90

Basically i want to split column data, remove ( - )and add days in next new column
I canyc use formula as I data will update on daily basis

I wanted to check the I number 24 is in which time line1 -30, 31-60,61-90,90-120 till the end of column

 

[vletm]

Vijayarc
Upload a sample file
which will show all needed as clear as possible
what would like to have after something.

 

[Vijayarc]

Hi vletm

Sorry, currently I don't have any sample file

My requitrequir is column" H "cell data has complete-25 days
I want VBA to split all H columns into 2 columns and remove (-) hipen like
| completed | 25 days |

 

[vletm]

Vijayarc
Do You ask that someone would close both eyes and write code which works?
I hope that You have taken backups before test any code.

 

[Vijayarc]

hi Vletm

as per your suggestion i attache sample file.please check an solve my query
thanks .

 

[Nebu]

Hi:

May be something like this?

=LOOKUP(MID(M2,SEARCH("-",M2)+1,LEN(M2)-SEARCH("Days",M2))*1,$T$1:$T$5,$U$1:$U$5)


Thanks

 

[Vijayarc]

Hi nebu
My file have dynamic data rows count will change on daily has
More than 1,75,000 rows, for Samle I given only 5 rows
Please help !

 

[vletm]

Vijayarc
1) Where do You need macros ... if only those seven rows?
2) If that yellow range is 100% needed ... then challenge
3) Check this ...

Okay ... You just add that You have 'more' rows ...
You can check those formulas and do Yourself it with vba.

hmm ...
Is 'output'-sheet created or use 'INVENT'-sheet?
If You run more than once that macro, do it add or overwrite results?
What about 'Sales country' -column ... delete or how?

 

[Vijayarc]

Hi

1. I need macro on invest sheet, in the output file I created ti show how the macro output in invest file should come (highlights in orange)
2. Yes I want to claulculate the days fall on which raange
3. My File has 55 columns, for sample i given only few columns, highlighted in orange when result should come
Please help!

 

[vletm]

Vijayarc
Without proper answers and changing case,
You would get something like this...
Press [ Do It ]-button