• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Merge & insert below records in main record?-How Many records below main, not fixed-dynamic

Hi,

Sorry for the repetition ; what I wanted to know was , given the contents of E179 and E180 as follows :

401/1....406/1....167/1....318/1....408/1....8/3......9/3......

8/5......9/10.....

what will be the total shade and total units for these two items of data ?

Narayan
 
Dear Sir,

all before "/" is shade no that will be just need to count
all after "/" is ordered units that will be sum

as per your above
401/1....406/1....167/1....318/1....408/1....8/3......9/3......8/5......9/10.....

total 9 shades
total 26 units

regards,
Chirag Raval
 
Dear Sir,

Many thanks its Rocks...really amazing ...it as working as magic..
you convert my work's hardness like nothing ....which till recent...really very hard ...

again many thanks..

there are 3 final points...(don't worry -not another process.)

(1) Sorting require only on "DP" (Column-"H") & then
"Quality No." (Column "C")
(2) Column "K" have Heading "Value" &
multiplication of column "I3" & "J3"-till data end
(3) subtotal required instead of total...
"DP" wise (Column "H" wise) subtotal of "F, G, I,& K)
so automatic get Grand total ...
(Actually "DP" means Delivery Period, DP 8 means Aug, 9 Means Sep, etc..)
(4) heading "Total Shades" & "Total Units" should wrap text "Total
(line break ) Shade so column maintain width shorter for print purpose

So whole report can says
"Report of Delivery Period wise given order with total number of shades & total number of units of course with & Value)

Again many ...many ...many ..thanks & hope little final help..

Regards,
Chirag Raval
 
Dear Sir,

Amazing...Great..Really rocks ...As per desired...(Required)

Oh ...Oh... Sorry to not mentioned earlier...(really forgotten) at previous..
1 last --Final point ...really sorry ..

"Quality No" (Column"C") need to remains as it is..but ..
also need to split same in 2 part next in new insert 2 columns after "C" ("C should be remain)

for example just refer "C3"..

(1) First 4 Number in column (newly inserted) "D" -
(2) no need to character "/"
(3) rest 6 digits (with leading Zero) in column "E"

so whole data shifted to right

(first 4 digits is for blend of cloth & last 6 digits is quality number -that's
pair of [Blend/Quality]

just it no further process pending ...

I can understand that you need to change column references in your whole code ...but that will be 1st & last time..

hope for last...

Regards,

Chirag Raval
 
Dear Sir,

if will be split...

Column "D"'s heading shoul be "Blend"
Column "E"'s heading should be "Quality No"

need to change also sort order as per message no 208's 1st requirement ..
(requirement is same but change column No Ref)

now sorting need on spited database's first sort on Column "J" ( "DP")
& then Column "E" ("which now become real quality no
with 6 digits --party give order first give order / decision based on this 6 digits...)

hope you can understand..

Regards,
Chirag Raval
 
Dear sir,

Thanks for your effort...its 10.30 P.M.now
& I am at home.. & I have no pc ..its in officeoffice
I will be revert you after check...

Its your kindness ...which bigger then your knowledge...
May be other expert.surly tired & leave this thread..
After attempt to fulfill this thread.
Due to my points raised one after one. & pray god
To complete this thread now with full solution..

Regards,

Chirag Raval
 
Dear Sir,

Perfect...Final...Amazing...How to thanks?
you don't know you great help to me...
& your kindness is also great ...you help me till last..
only "Gurus" & Parents can do this ...just give...without want anything ..

this thread meet the solution..

Again thanks

Regards,
Chirag Raval
 
Dear Sir,

Also thanks
you great help also to give code in 2 parts.

(1) Public Sub ProcessDataAndMerge()--just merged perfect rectangle range-(without any blanks )as report if we want to do anything on it..
(2) Sub InsertColumnsAndProcessData() --can be manipulate report generated
after merging with adding extra columns & with sorting-totals-subtotals ...

again thanks

Regards,
Chirag Raval
 
Back
Top