Search results

The person who built this is no longer with our company, so I am trying to learn. I will try to start at the beginning then.

http://rapidshare.com/files/976557196/TEST%20Infection%20Control%20Report%20Ver%201%203.xlsm Hello! I am very new to learning VBA and attached is a worksheet that I would like someone to take a look at and see what may be wrong with the code because I am having trouble completing the...

Since I have joined this AMAZING forum... only two or three weeks, I have received so much help, and I am getting so much better at working with excel, I can not thank you all more for your help!!!!! THANKS Una

Thanks Deb & Kevin!!!!!!!!!! I have been away from the formum trying to use the formulas that have been so graciously provided to try to facilitate the processing of over 1000 claims that need to be billing witin two days. I will try the formulas above as soon as possible. Deb - when I try to...

Hi Deb!!! I get #VALUE! I must be doing something wrong? Una

Hi I have a long list of dates that are fomatted as 3-12-13 that I want to format under custom date as d-mmm-yy. 12-Mar-13. I tried to do this but it does not change. I tried to change it to a number and that didn't work either. Any help is appreciated. Thank you Una...

Hi Deb and Shakeel - It is definately in the format of the date. I formated my date your way and it WORKS!!!!! Thanks so much. Una (very happy):))))))

Hi Deb - I hope I am allowed to put your name in the title - if not good - let me know. Please see the attached - I changed the names for confidentiality. I seem to not be able to copy the array, not sure what I am doing wrong, but I am doing something wrong. I keep getting "can not copy...

@Debraj Hi Deb!! Please see the attached - I changed the names for confidentiality. I seem to not be able to copy the array, not sure what I am doing wrong I keep getting "can not copy array. http://my.rapidshare.com/UNAB/12387 Thank you for looking at this. Una

Thank you Deb. I assume from one of your posts you celebrte Holi... I hope you have a very Happy Holi. Kindly, Una

This is the correct link - http://my.rapidshare.com/UNAB/9276 Thank you Una

This is the correct link - http://my.rapidshare.com/UNAB/9276

Great history - Happy Holi to all that Celebrate!

Deb had graciously helped me with this spreadsheet - Deb - Thank you so much... again!! How do you copy the array down for the month to include more patients? Thanks, Una http://my.rapidshare.com/UNAB/16430

Deb - Thank you so much... again!! How do you copy the array down for the month to include more patients? Thanks, Una http://my.rapidshare.com/UNAB/16430

Deb- The K5 is amazing for the month - you are so smart!!!!! Thank you immensly. I see the 07. Unscheduled is causing too many problems here because it is the only Type that can occur any where in the mix of types and depending on the days assigned to each type prior and after it - the...

Hi Hui - Thank you - could you please check sheet two in the attached, here is what comes up when I put your formulas in, I may not be entering them correctly. We bill monthly from 2/1 - to 2/28 and "Types" can overlap dates at the start and end of month, so I trying to find a formula that...

Hi I cleaned up my spreadsheet that Deb and Narayan had helped me with and have two more questions if anyone could help. The questions are noted in the spreadsheet as well. 1. NEED FORMULA FOR: IF A14=A13 AND H14 = 07. Unscheduled THEN E14 WILL BE 7DAYS LESS THAN D14 THEN F13 WILL BE...

I am writing in upper case as it is easier with all this information. YES!!! YES, BECAUSE WE CAN ONLY BILL FOR ONE MONTH AT A TIME .... FROM 2/1 TO 2/28 SO IF THE 01.5-DAY DATES COVERS END OF FEB AND BEGINNING OF MARCH - THEN IT IS SPLIT BETWEEN THE TWO MONTHS - BUT SINCE DEBS FORMULA...

Good day Narayan - A person can have multiple dates associated with a admission (all based on the date of entry to the hospital). Doing this manually - this is what is displayed in G and H 2/6 - 2/19 (I tried to edit the post and the below all runs together) RUG ADMIT...

I TRIED THAT - WOW WOW AMAZING - THANK YOU - THAT WORKS!!!!!! WHAT IF I ADDED ANOTHER COLUMN ( I ) TO LIMIT THE CALCULATION TO THE END OF ANY GIVEN MONTH - SO THAT "I" COLUMN WOULD GO TO FEB 28 OR MARCH 31, DEPENDING ON WHAT MONTH OF THE YEAR. THANK YOU SO MUCH!!! UNA

thank you kindly!!! Good night

Narayan - can you trythis please. Una http://my.rapidshare.com/UNAB/1140

Hi Narayan - Please bear with me, I am trying to determine how to give permission. Thanks. Una

I tried RapidShare - hope this works -thank you!!!! Una https://rapidshare.com/files/1237617047/SPREADSHEET%201.xlsx http://rapidshare.com/files/3385884688/SPREADSHEET%202.xlsx