Hello and welcome! My name is XXXXX XXXXX I look forward to assist you today with your question and provide the best answer possible
kindly share the spreadsheet and also the requirement that you want to achieve
Thanks - I am trying to do different quoting templates and gather the information from the main Census Data page. They have changed up some of the requirements and I am having difficulty filling in all the information on the UHCNEW, New Allsavers page. Also, on the census data worksheet - I need to calculate the age of the children and spouses but do not want it to show an age unless there is a date of birth - it is defaulting to 114. I cannot seem to get that figure to transfer to the other pages.
I do have some issues with the tab Aetna but that is a different story that if you can help me with this - I will address.
i have a pre-schedule engagement due to which i will not be able to work on your assignment. however, i will redirect you to another expert who will help you. thank you for your patience
not sure if you received the first information or if someone is going to contact me again
Yes, what I am doing is cutting and pasting from a separate excel workbook the basic information on the original Census worksheet to the CENSUS Data tab. Last name, First, zip, DOB, etc.
My goal is to automatically fill in the remaining spreadsheets with that information. Just the UHCNEW, FLorida Blue, New Allsavers. For the New Aetna they have changed the format and that is something that I will need additional help with.
So I have been playing with different formulas and if then statements but there are a lot of formats in this and some things are just not copying over - like DOB calculations and if there is no DOB, I don't want it to calculate age
Okay, on the Census Data worksheet - under DOB Child1 - I put the formula in to calculate the age based on O13 (today's date) - minus the DOB of the child (same with Spouse) but if there is no child or spouse that exists - it calculates 114.
Can you please look at the New Aetna worksheet and let me know if there is a way to extract the information on the Census Data worksheet and put in the information. My concern is mixing columns and rows and getting the correct information.
Not sure if adding six rows of children to each Subscriber would work or if there is a better way.
What I am trying to do is get the employee data, the spouse information and the possible children information into the template that is set up under New Aetna. The information is all in rows on Census Data but on the Aetna template the information for the spouse and possible children are listed in columns.
Not columns, but rows. I am trying to get the information like Subscriber, Spouse and Child information from columns into rows on the Aetna.
Have been just trying to copy formula to match cells, but feel there is an easier way.
I am going to a meeting and I will not be back until 1 PM - EST Thanks for your help
Yes, I am looking for all the columns in the New Aetna to be filled in with the information on the Census Data for the Subscriber only - I only need the DOB and Gender for the child and spouse information. My confusion comes in with the information on B14's spouse is located in column Q, R and S, which I only need that information filled in F&G on the New Aetna sheet.