Search results

I have just completed the bulk of my lengthy consolidated report assignement. Each report has links back to the source information. I have zipped everything together, and moved it to another work station. I first open all the source reports then opened the consolidated reports.... Of course the...

NARAYANK991 in response to your question Yes, I am still able to enter 5 into Cell A30... When I should be unable to enter anything other than 1,2,3,4 correct?... I dont' want any one to be allowed to enter anything other than 1, 2, 3, 4, single or combination of the numbers in the numerical...

Thank you all for your wonderful input... This is the source report that data is pulled into other reports and in the source report I wanted a specific cell restricting inputing. I felt this would esure they are entering quarters allowed. such as; 1,2,3,4 or 3,4 etc.. preferrably in that...

Yes on the description cell it's at a granualary level for the field office that has entered the request for payment (examples: travel to pittsburg, or lodging at Motel 6 or printer purchase/box of 8x11 paper) and on the source report that the comparision is on a corp level of terminology...

I am trying to the type of data entred into a cell: The entry can only be a combination of 1, 2, 3, 4. (The 1, 2, 3, 4 specifies quarters). Example they could enter 1, 2 or 1,4 or 1,2,3,4 or 1,3,4...get the idea.. At first I tried lists but, the list became long with all the combination...

1. You have a cell in your order tracker worksheet , which contains text , signifying the item description. Yes... You may also add another cell or two more cells , which will contain text / numbers (?) , signifying the Reference Document No. and Predecessor Document No. Yes... 2. Some (...

I actually have five data reports to pull the information from and see which of the five data reports has the information that would apply to the item listed on the dept. order tracking report. On the order tracking report I have a section Actual Dollar Amount, which will be populated once I can...

Bingo! I had it on to ensure all data could be seen. Thank You!

I am Sorry I am so consummed by my little project...12 hour days... Crazy!!!...Your guidance is greatly appreciated and I commend you on your patients and ability to provide me (newbe) guidance on such a foreign subject. Also your ability to over come my inadequate explaination/recap and quickly...

Luke, Its a linked cell situation. The cells are linked to the main report... The main report is my problem. The rows and columns change size.

My spreadsheet report is separated in sections... I have what looks like headers (Taking up two rows) that provide details on what is in each column. It seems as though when I accept my updates since these all the cells are linked to outside reports the titles at the beginning of each of the...

I have a main report that will be linked to another tracking orders report for a link data pull into the main report (all departments dumps data into when ever a new request is made. I know it would be nice if they had a database, but I am not as lucky... My report has specific verbage that I...

It let's me know to enable macros. I enable macros save and close and open again. Once I open it again I protect the sheet. I save the file again... Then I try to select the group drop down or rollup and it gives me and error message that this can't be done unless you unprotect the...

I could not get the macro to work.

SUCCESS!!!! Thank You! As well I am still having problems with securing (protecting) this mess of a report... When I protect my sheet it won't let the groups roll-up or down. You know the group and ungroup feature in excel. If the spreadsheet is protected and locked these function do not...

Scratch my comment about not see the formulas in your posted example. I was really tired and didn't think to down load... thank you!

I pulled up your file but, I am not able to see the formula and where it's placed... The helper column is listed on the field reports and as well on the detailed summary reports specific to department heads (I am going to hide the helper column at the detailed summary department head report...

Okay, my formula for the helper column is nothing accept my linked information: This column is a linked from the field report providing the qtr#: my link in that cell looks like this: ='OPS SPR FY11-12 Nrthrn (G)'!F32..... Can I add the formula too it and if so how????? Formula for the helper...

The field report which are linked to the detailed/summary roll-up report are where we are having the issue... The field team will not separate out on there report they submit the complete break down of each quarter and dollar amount. Instead they liste the monies to use, which qtr column...

Thank you!!! I was able to use the first scenerio: I confused on the more advance version... I am so not a math/numbers person. The first scenerio I put it in the roll up department reports category details, which has been separated out with qtr sections. I just added your suggested qt column...

RATS!!! My report is due Monday.

Heres the other one if you sign in. https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!109

https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!109&authkey=S16Crx6G9t8%24 I hope this is right... Thank You

Is there another alternative... I tried to signup for google docs and it would not let me becuase a repeatative age error keeps occuring... Tried 3 times.

Okay your going to have to help with where I go...I am new to this site