Search results

Im soooo sorry to keep bugging you SirJB7, but I dont know why I cant figure this out! https://dl.dropboxusercontent.com/u/35552808/CHANDOO_SIRJB.xlsm Here I have uploaded my file. I just can't figure out how to get the macro modified to fill report like I want. :( When I run the macro...

Thanks SirJB7, I will run it through my file! :)

SirJB7, Thanks for your help. I uploaded another sample file (with your macro, only modified for my file): https://dl.dropboxusercontent.com/u/35552808/CHANDOO_SIRJB.xlsm the macro is working, but was working on the first column in the REPORT. I think maybe, my "fictious" numbers might...

Hi SirJB7...once again, to my rescue! ;) Thank you SO very much for this... I will test it out today but knowing you, I am sure that it is awesome and works amazingly! I do apologize, the numbers in the Report Table, were just for display purposes...not accurate. Thanks, SirJB7!

Hi guys? can anyone suggest a faster formula to achieve this: https://dl.dropboxusercontent.com/u/35552808/SAMPLE_chandoo.xls So, essentially, i have a list that I need to compare to my master database. If those list of IDs exist in the database, count the number of times where their...

You- SirJB7- are truly my SuperHero! I am sorry, I just got back to this site, today. I tested it with my file....it works amazingly!!!! :) Thank you so very much!

Hi my Excel Heroes!! So, I am in need of your super assistance again! :) I update my files, on a daily basis and it would be very helpful to know of the changes that occur on those files. Can someone please help me with a macro to identify these changes? *The number of columns and column...

Perfect~!!! Thank you SirJB7!!! :)

Thank you SirJB!!I will test it out! :)

the macros are close...but can we pls tweak them a little?

Hi Guys! I am attaching my sample file. https://dl.dropboxusercontent.com/u/35552808/SAMPLE-CHANDOO.xlsx The number of columns will always vary. This might make it easier to create the macro....THANKS!! :)

so, cell B1, would be autofilled..."copied"...down to the last cell in column A

so if column A has 200....columns BEH, would be filled to row 200

oh, i am sorry. For all cells with as many that are in column A

Hi SirJB7! I hear a "Welcome Back" is in order?! :) So, yes- a new column would be inserted before columns B, E & H. Then I would like column B to be filled with "123" and column E to be filled with "345.3" and Column H with "05.1"....

Hi all! So, I have a wksht with a bunch of columns. Col A- IDS Col B- A 123 Col C- B 123 Col D- C 123 Col E- A 345.3 Col F- B 345.3 Col G- C 345.3 Col H- A 05.1 Col I- B 05.1 Col J- C 05.1 etc. so, what i basically need is to find where the column header contains "A" to insert a column to the...

amazing!! Thank you Narayan !! :)

=SUMPRODUCT(--(B1:B4614<=$N$3),--ISNUMBER(MATCH($A$2:$A$4614,J2:J26,0))) this formula is not working. Column A has over 4000 ID Numbers Column J has a list of 25 ID Numbers Column B has over 4000 Dates Cell N3 has A Date I need a COUNTIF/SUMPRODUCT Where IF the 25 ID Numbers exist...

That works!! THANK YOU NARAYAN!!!

Thank you Narayan, i will try the formula and let you know! thank you sooo much!

hi sorry: here is the link to the workbook: http://dl.dropbox.com/u/35552808/Book1.xlsx

hi sorry: here is the link to the workbook: http://dl.dropbox.com/u/35552808/Book1.xlsx

hi Suresh! thanks, i have created a sample workbook. cant see how to attach it?!

i have 40 columns across my sheet. columns 1-15 are simple fields...columns 16-40 are fields with dates in them. What formula would be best to search across the column headers and find a text then do countifs if the dates within that specific column are greater than or equal to TODAY? instead...

so my countif are like this: 1. filters (if country =us & state =MD & county=Polk, then for Field12, count all dates that equal to or before Today) 2. filters (if country =us & state =MD & county=Polk, then for Field12, count all dates that equal to or before Today+7) 3. filters (if...