I have this data table where the totals are in the last(bottom) row.The number of rows of the table increases as new records are added to the bottom of the table. Now, the problem is , I need to have the Row that contains the Totals alwas on view no matter how big the table gets and no matter how far down/up the workshhet is scrolled.
I have tried Freeze Panes/Spliting adding new window , live shapes etc but all look dodgy and bring their own set of problems.
I have also thought about putting the Totals of the table in a row at the top of the worksheet and freezing the panes at that location but having the Totals showing at the bottom of the Table is the normal intuitive way .
I have a list of names (300 now but growing every month by 100-200). In the row with the name contains data I need to view: date, $, #, etc...
I want to quickly see whos name appears the most, 2nd most, 3rd most, etc.....(at the end of the year I will have 2000+ names, most names will only be listed 1x, I suspect nobodies name will be listed more than 60x.)
I also need the ability to view the relative data of the person's name that is listed most, 2nd most, etc....
is it possible to select the data to view by running a macro. my table is based on dates. i would like to see all data before the date i run the table and 6 weeks in front only.
I have got a table, with a range B1:CC200. I have been able to run a macro which pops up a form and shows the particulars of a selected month corresponding to those in the table. (e.g., say entries in column D pertaining to say, March 2012 are shown in the form). Problem is I want to be able to update the entries using the form, but no no success. Am quite new to vba but the code I tried to use on the command button after updating is shown below
Private Sub CommandButton1_Click() TextBox1.Value = Application.Lookup(Range("A1"), Range("B1:CC200"), Range("B2:CC2")) TextBox2.Value = Application.Lookup(Range("A1"), Range("B1:CC200"), Range("B3:CC3")) . . . TextBox20.Value = Application.Lookup(Range("A1"), Range("B1:CC200"), Range("B20:CC20")) Unload Me End Sub
Where A1 is the month in question, B1:CC200 the range of the database and row B2:CC2, and B3:CC3...., B20:CC20the data I need to update. .
I have a pivot table where I would like to add a column for the date next to each item listed in the pivot table. When I do this the pivot table sums the date, which is an incorrect number because it is adding a date to other dates. If I move the data to the row option it moves it under each item and the formatting is off. Is there a way to add the date in as a column without it sub totaling? I need the other columns to keep their totals.
I also was having issue creating a calculated field - below the total to show cost per item and then the profit. Is this possible.
I created a screen shot example to show what it is doing. (1st picture)
Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
if there's a way to either define what columns or rows are printable or to somehow leave columns (or rows) as visible within the print area but omitted from printing as if they were hidden.
In my CAD package I can simply elect to have certain collections of information "non-printable", is there any way I can do this with columns without having to rely on people managing to laboriously (sic) hide and unhide columns either side of printing a document.
I've design a small little excell program that brings up a form and hides the excel workbook upon opening. By using the form the user is able to input data to a worksheet in running in the background. I've added a button on the form where I want the user to be able to open the worksheet which is password protected and view or print the data. I've already got the code to hide the workbook, protect and unprotect the sheets, I just can seem to get the code to view the one worksheet.
I'm trying to create a new report and looking to get the top and bottom ten from a list. My original idea was to use the LARGE and SMALL funcions. However, when I use those because some values may be the same, the corresponding lookup values would be incorrect.
If I have Vendor A,B,C
VendorA 100% VendorB 100% VendorC 98%
My report would read this:
VendorA 100% VendorA 100% VendorC 98%
I'm using INDEX with MATCH to bring back the vendor. I then figured, I could just link the cell to the top 10 cells from where I am pulling from, which wrks for top ten, but won't work for the bottom ten.
I'm pulling the the data from a sheet with a query so I won't know where the ending data is unlike where the starting data begins. I then thought that maybe I could use an option button to control the query and just change the sort order. But, I really don't want to use VBA on this report, which I think I would have to do for that idea to work.
I use a two monitor setup driven from a Radeon 9550 graphics card, but the problem I have occurs on a single monitor as well. When I open multiple workbooks or worksheets I can only view one at a time the other remains embedded behind the open window. Nothing I know of will let me view both at the same time.
If there are two open worksheets full size on the screen and I minimize one they both minimize. If I decide to close one workbook/sheet down all open workbooks/sheets close down as well. Can I view two workbooks at the same time? Can I close one down while keeping one open?
Ive seen on someone elses workbook the first 6 columns are fixed (always in view) then you can still scroll across but those first six columns always stay in view.
i was doing something in Tools -> Options -> View, & suddenly the dates in my sheet disappeared & some numbers came up, i can view the date in the formula bar, but can't be viewed in the cell, & i am also unable to do the alignment for the cell.
I'm stuyding the book "Professional Excel Development" which has a Project Template and an addin with several modules and a worksheet. I can view the addin's modules but not it's worksheet - is this normal for addin's? I haven't worked with them much before.
I am building an application through Excel to update specific internal website information. My question is, is there an easier way to identify and view the tags on a web page without having to right-click and "view source"?
i am trying to use this code to view the workbook (WK) in the userform named WK
it can not reconize .spreadWK
Private Sub UserForm_Initialize() Me.SpreadWK.Cells.Range("A1:E10").Value = ThisWorkbook.Worksheets("WK").Range("A1:E10").Value End Sub however this is saying that it can not reconize .spreadWK
I have 1 workbook which summerizes 3 other workbooks. My question is, is there a way that if I hide a column(s) in 1 workbook (by either using Hide or Outline), the corresponding column(s) will also automatically be hidden in the Summery workbook?
Or, is there a way that I can make the Summery Workbook only display / Link to cells that is been displayed in the source workbooks? I hope to do this dynamically, so if something is hidden by Outline or Hide in one of the workbook, the affected cells in the Summary workbook will also go in hiding.
I am hoping to do this by some magical Excel Function, if not then by VBA (I'm not that good a VBA programmer), if not even that, then maybe some free Excel Tool someone knows?
I have an Excel sheet that I want to scroll up and down and I want an area in the upper right-hand corner to display static information. This information could change as more input into the sheet is performed, but it always must remain in the upper right-hand corner.
For example, let's assume the sheet has 200 rows to enter in a credit card application. There would be an area in the upper-right that would display information for some of the cells that were typed in. So as you type information, labels would display information from the form. I know that I can program the selection change event to re-position the box and labels, but if I scroll off the screen, the area does not stay there until I click on a cell on the page. I am using XL2003.
I have some command buttons on worksheet. I want to do next: when I am click on command button1 I am see a VBa code of command button 2 How I can do this?