Can you attach the document to this question? You can use the paperclip to attach the document, even though it says image only. If you have sensitive information, save a copy with two lines of sample (aka fake) data in the same format and I'll work with that to produce a pdf with instructions for you.
so the data is going into the columns on sheet 2
where is it coming from?
I created all of the other columns after column one. The columns are in place with the format I am trying to create.
but where did all the information come from?
oh I see it now
The information came from a message database.
I didn't have the first column height set correctly
sorry about that
Oh no problem!
I could only see the first line of text
so I was looking for that information on the other sheets
I am so sorry! Sheet 2
I'm working on it now
I'm building formulas to parse the data, it's sometimes as much art as science
Ha! Yeah, Im beginning to grasp that. =)
do they all get a repaged time: section?
Ugh! They dont....only if they do not respond within the first ten minutes. Im sure that has to make things more confusing.
it does a little bit
I'm going to get everything else done, then break for dinner and figure that out
That sounds good. Thanks for all of your help.
Here is what I have so far, lines 2 and below. I am breaking for dinner and will think about the best way to handle the repage.
This looks great so far!
all you have to do is copy down the formulas to the other rows
if you highlight the columns you want to copy in one row, it outlines the area in a black box. The lower right corner will have a square, left click on the square and drag the mouse and it will copy the selected columns over all those rows. Much faster than copy paste over a large area.
And honestly, we do not repage very often. If I need to enter it manually, it is not a big deal.
i'm figuring it out now
i also have an issue with another entry that doesn't have a phone number following the doctor
That really wont be a big deal. Because the information is not there, I may have to enter it myself.
i found that
fixing one last thing
found another small issue, correcting it now
No problem!- Thank you for your help!
Ill be back in five minutes.
I think I've got it working for the standard cases now
actually, this one has one more fix for the phone number of the doctor
Dude, this looks fantastic! So all I have to do is copy the formula?
Great. I appreciate your help! You will make months to come extremely easy!
Glad I was able to help.