view

Hello, I want to create a dropdown list with some text and after the selection of the text with the submit button, I want to display the user to view the range of cell in the present worksheet. To be more precise : Ex: the user select the the value C1, which is a table in the work sheet out of...

Hi, I have 24 pivots in sheet1 and in sheet2 I have a dashboard which will have the numbers from the Pivot output. I have used GETPIVOTDATA to fetch the data from Pivot to my dashboard Table. I have 5 slicers connected to all the 24 pivots. I have years as data in one of the pivot as columns...

Hello everyone, i tried to search and find what I am looking for but with no success probably because I cannot describe it very well. I will try to explain what I need with a picture. Thanks for your assistance in advance.

Hi Experts, Please assist me in adding one more knowledge here. Whenever we filter to headings, i observed that suppose if my cell selection on col AO or any other cell, if i use Ctrl+Shft+L for filter, sheet view jumps to left i.e. col A side.. How do i keep freeze this view on my selected...

I am running office 365 and have Excel 2016 on my machine. I have a spreadsheet that is in "Page View" but I only have info on the 1st page. However I still see grayed out pages beside and below. Is there a way to only show the one page without the grayed out ones? Regards, L. Ambrose

Hi All, Hoping someone can help me with this. I assume this will require VBA which i have little knowledge of, In the below example. I want to automatically scroll to and select the cell of the equivalent Week number as the user inserts into B3. So the result would be, M3 is now selected and...

I have a main form named "frmTagEntry". The Subform is named "subTagEntry". I want to be able to view all of the records in the subform in datasheet view and have them linked with all of the records in the main form in formview. Basically mirror the form in split form view but using a subform...

Workbook has no tables and no protected sheets. Have created several custom views but excel does not successfully switch between them e.g. view “males only” works. Switch view to show people from e.g. certain town - also works but switch back to “males” only view and it fails - includes “females...

Hi, I have a problem with loading data from a web-page with Power Query. I get an error message that it can't view data beause of Internet Explorer Compabiliy View. And when I try to load I don't get any content, just the html framework. Why is this?

I created a Split form. Used the wizard. It put my fields in the detail section - which I can see all of them and edit them when in Design view. But when I go to Form view there I don't see my fields. I see them in the datasheet section on the bottom and I see the buttons I put in the form...

Hi All I would like my workbook to default to not view zero values with VBA. Thank you! Russ

Hi, I have an issue with CTRL+SHIFT+ARROW, excel selects the column/row content, by it doesn't change the view to the top/end of the selection (eg: if I want to select all column A and I have 312 down rows, CTRL+SHIFT+BOTTOM ARROW selects all 321 rows, but my view remains where I started my...

Hi there, I have a multi-tab spreadsheet where raw data is dumped in a "data sheet" tab on a weekly basis. This data is pulled into the "main view" tab. I'd like the "main view" tab to always reflect the same data in the first column as the first column of the raw data tab. Initially I set it...

code Sub test8() ' ' test8 Macro ' ActiveWindow.ActivateNext Application.ActiveProtectedViewWindow.Edit ActiveWindow.ActivateNext End Sub Hi Experts, I have a protected view file and a normal one. I am trying to run the above code from the normal one but I'm getting run time error...

Hello all, I have a worksheet ("ws_schedule") with column A populated with a series of values of "ref", "fcn", "fac", "x" or "x2". These values help the filtering process needed to create unique lists for a userform listbox. The user can choose which series ("ref", "fcn", "fac", "x" or "x2")...

Hello gods of Excel Universe!:cool: I have been trying now for a month figuring this out but to no avail. Also i have searched the forums and found none related to my issue. Basically, i just want my date picker to display the current month, although i have the "Today" date displayed at the...

Hello Where can i see my all and old subscribed threads. ? Only last 2 months threads i am able to see and before two monthe the threads am not able view I sincerely request Moderators of this forum to help me retrive my old subscribed threads. Thanks and Regards SamD

on excel 365 how do I share a wb so several ppl can view it at the same time?

I'm using a multiple page form and I'm looking for code to view the selected file from my list box in the AcroPDF1 frame. I'd also like to print PDF file. I'm trying to insert an image of my form to view but I'm unable to do so any suggestions?

I used powerview in excel 2013 and excel 2016, but I dicided to upgrade to office 365 rather than office 2019. Has Microsoft dumed down office 365 and remove power view? To installe office 365 I had to remove office 2016. Is there a way to ***** about this. Richard