Search results

Thank you very very much luke, debraj and faseeh, its working a little slowly but its okey.again thank you very very much guys and also thank you for chandoo for this site clap! clap! clap! wowwwwwwwww..... thank you and god bless, realtop17 yes!!!!!!!

Hi debraj roy, NARAYANK991, yes! yes! yes! its working thank you very much guys your the man! Just one thing can you adjust the VBA CODE for insert module my actual work sheet is look like below. sory i'm VBA code beginner. date CUSTOMER NAME PART NUMBER serial no. Remarks cntrl.No...

Hi Faseeh, thank you for your effort. what i mean is sheet1 is my reference then using formula all new date of duplicate serials in sheet1 remains and the old date transfer to sheet2 automatically. thank you, realtop17

Hi good day, question: How can i seperate duplicate copy latest date and old date in seperate sheet automatically. let say sheet1 is my refernce i want the old date transfer to sheet2. like ex: see below sheet1 1 s/n date 2 ab july 1,2012 3 cd august 2,2012 4 ef...

Thank you NARAYANK991 wow!!!!!!!!

Hi Narayank991, thank you for your clarification about my question, base on your example i want the latest date output october 2012. can you give us the formula or the best automation like macro. thank you, realtop

ex: sheet 1 1 S/N DATE 2 AB 1/1/2012 3 CD 1/1/2012 4 AB 2/2/2012 5 CD 2/2/2012 6 EF 3/3/2012 ex: sheet 2 1 S/N DATE 2 AB ? 3 CD ? 4 EF ? this are the result iwant when ilook up sheet2 1 S/N DATE 2 AB 2/2/12 3 CD 2/2/12 4 EF 3/3/2012 Please help on...

hi luke, luke thank you for helping me on this problem it realy works! luke can you put the "fg" insted of false and "allocated" insted of true in helper column. thank you, realtop17

HI Luke, tnx i got it, when i pasted the serial in allocation sheet the result in monitoring sheet is "true" and it "false" when no same serial are pasted in monitoring sheet. tnx bro! follow up question. insted of false can you do it fg and insted of true do it allocated. i can not...

Now i know the helper column thank's for that bro! i followed your sumproduct formula this is i got " N/A" i'll pasted the macro you gave i also delete the word "'Which column is your helper column?" and i rage the cell ("C:C") which is my actual helper column but nothing happened. pleasee...

Hi Luke, i have a question what is helper column? please luke let me know...plssssssss.... Sub DeleteRecords() Dim LastRow As Integer Dim SearchRange As Range 'Which column is your helper column? luke please give me the example for helper column Set SearchRange = Range("C:C")...

Thank you luke now i have the idea i'll try 2mrw its getting late i'm going out now... agin thank you very much...

how can i use the macro? i only do is to pasted the macro you give i press alt+F11 in VBA PROJECT SHEET1 (FG) but no happen. please help me how to use macro im macro beginner.

Hi all, please help me on this scenario i'm using excel 2007 In excel WORK BOOK sheet1 title "fg monitoring" and sheet2 title "allocation" fg monitoring is a soft copy wherein all information of finish goods are placed such as serials nos., p/n and so on.. and allocation is also a soft copy...

h9i sir can you please show me the step by step procedures of below sample command button. best regards realtop17 Sub ColorChange() Dim OriginalColor As Integer 'You need to make a note of what the name 'of your shape/button is ActiveSheet.Shapes("Star1").Select 'Store original color...

hi sir, can you please give me the step by step proces of below macro command buttom. best regards Sub ColorChange() Dim OriginalColor As Integer 'You need to make a note of what the name 'of your shape/button is ActiveSheet.Shapes("Star1").Select 'Store original color OriginalColor...

WOW!!!!!!AMAZING......... thank you verry much for helping me.... its a big big help

column a column b sachin mumbai (old location) sachin pune (old location) sachin delhi (latest location) my follow up qeustion what if i only need is the latest location and no need to post or to display the old location like example below this is the out put i want see below column a column...

I need help for vlookup, I have a table, column A has names & column B has locations. The problem is I want to populate latest location for the name, say for example, Sachin is populated three times in the column A & location is Mumbai Pune Delhi. I want a formula which will give me the...

thank you verry much guys now i can use it.

thank you fred but im beginners in excel where can i find value field setting

using vlookup how can i get the latest date if the table array have the same or duplicate number ex. serial date 123 5/12/10 124 5/12/10 125 5/12/10 123 5/17/12 124 5/17/12 i try to lookup these serials but the old date are captured please help on this. thank...

using vlookup how can i get the latest date if the table array have the same or duplicate number EXAMPLE. Serial Part no. contorl # date R20120404 P04-060252-00311-E000 ctrl 10 4/1/2012 R20120484 P04-060160-00111-6000 ctrl 10 4/1/2012...

sorry please disregard my email.

weekly inventory are our weekly task using scsanner we do manual scanned over 7,000 serials we scanned serial per location see below exsample. how can we monitor the incomning units and out going units using excel. example: serial # p/n location #...