Search results

Hello Guys, Good day, I am trying to split comma delimited data in column K & L and copy relevant data to new rows. for Example K3 contains 50, 50 and L3 having 997795, 993795, I want to split both cells in 2 rows, so K3 should be 50 and remaining 50 along with all data in row 3 will be copied...

Hello guys, good day. Need help in copying data from Database file (Sales sheet column A to M) to another file named CC-KHI-S1, base on cell N1 value say CC-KHI-S1. Explaining a bit further, what I want is macro to look in CC-KHI-S1 file cell N1, and match it with all the rows found in...

Hi @Asheesh Many congrats my friend for your first :awesome: k. We have learned a lot from you, hope to see more brilliant post. Keep EXCELing. Regards,

Hello Forum, Greetings & Good Day... I am looking for a VBA solution, and need your help again after a long time :) Case is, we offer discount percentages to our customers, based on Trade Price (TP) Column G. We somehow managed with 2 different workings highlighted in different color. RED...

Hello Everyone, Just thought to share few custom formats for Dates, for those who don't know: English: [$-0]dddd, mmmm dd, yyyy Hindi: [$-39]dddd, mmmm dd, yyyy Urdu: [$-20]dddd, mmmm dd, yyyy Persian: [$-29]dddd, mmmm dd, yyyy and many more, go ahead and explore... just change [$-0] to any...

Hi, Just thought to share my suggestion: I was managing my personal details a while ago and found: "Upload a Sample file to get a quicker response" which I thought not necessary here. @Mods / Ninjas If you found the post unnecessary, delete this. Thank you and warm regards, Khalid

Hello everyone… Once again need your help. I am working on a sheet where I need to make a loop of +1 for column B values, until Column D values match with column E values. Current loop is working fine but it runs after one by one row. I need my all loops runs at the same time, not one by one...

Hello everyone, Greetings of the day... I am uploading a sample sheet with some data. (actual sheet is little bigger) I need a formula in Column A to get serial numbers (1,2,3,4,and so on...) You can see the Column A having merged cells and they are not even identical. Simply putting =A4+1...

Hello Everyone, Greetings... I am working on a sheet where i get TRUE / FALSE for all checkboxes. 64 Check boxes placed (Range = O6:O69) Currently i m using this: Sub Button66_Click()...

Hi Everyone... I need to know is there any format to display date i.e. (01/01/2014) as JAN-14 ? I tried Capital letters in custom format MMM-YY but result is same as mmm-yy.

Hello everyone, Greetings... Once again need your assistance, I have a sheet like this: I need to sum numbers only (not dates which are mentioned in brackets) Although I can manually do =C4+C6+C8+C10 ….. And put a ' before each date But this is not a good way to maintain a sheet with more...

Hello Everyone, Greetings... Once again need your help. I tried to get N/A for the cells having 0 value, using CF: =(A1<1) Further I need, it shows N/A too if cells are Blank (Range = A1:A5). I tried my best to get but :( Is there any way? Sample file also attached. Thank you, Khalid

Hello Everyone, Greetings... I have a sheet where I have manage the dates in Column A with custom format 00"-Dec-2011" (fast way for data entry purpose). See below image: You can see that the custom format is not same in all rows. Sample sheet also attached. Is there any way to get the...

Hello everyone, I need to apply a CF but dont know what to do. Your help is required. I have a data like this: I have applied 1 CF in the TOTAL (TOP 1) Now I need to apply same CF for Months Name. i.e. July-14 become GREEN. Thanking you in anticipation. Khalid

Hello Everyone, Greetings from Pakistan... I am trying to get qty with Minus percentage but not getting the required. Column 'B' = Actual Quantities Column 'C' = 15% of Actual Qty. Column 'D' having Total Qty. (actual + 15%) Required Column 'G' a formula that will calculate Total - 15% Bonus...

Hello everyone... I have download some US Migration Dashboards, all of them are awesome. I am receiving an error, and dont know what to do: (Suriya Banu Dashboard) Any suggestion? I am using win-XP and Office 2007. Best Regards, Khalid.

Hello Everyone, Greetings from Pakistan... I need a formula to get result of the cell without brackets "( )" E.g. Cell C2 contains: (10 x 20's) Required formula or custom formatting (which ever is possible) Result should be like: 10 x 20's Thanking you in anticipation. Khalid

Hello experts, Is there any way to change the font or font size in conditional formatting? Thanking you in anticipation, Khalid.