Get instant live Excel expert help to learn how to find range in Excel

How do I filter a Pivot Table by a date range?

Hi Dim wbook As String Dim filename As String filename = Range("B2") wbook = filename Workbooks(filename).Activate i am unable excecute this macro .

Hi I need to activate excel file from Macro file cell reference value. B2 is formula based cell and file name created as cell reference b2. B2 cell reference file already opened but i need to activate that file. Below is the code here. i am not able to open this file. Sub Work() Dim wbook As String Dim filename As String filename = Range("B2") wbook = filename workbooks(filename).Activate End Sub please help us me to open this file.

Hi when I try and refresh my data input i receive a message saying Pivot Table field name is not valid when I try and change the data source it won't accept the whole range only 5 lines of it not 700! I am sorry I am not sure what you mean by the file?

Needing to do a range formula but it involves using the same cell twice.

Hi, I'm trying to set up excel data validation from table column, and want it to be dynamic so that if the rows increase the validation applies. I named the range, then set the data validation to =countif(namerange,c2)<=1. I see the validation in every cell, but it allows me to enter a duplicate. what am I doing wrong?

Need to populate ParentID and AttachIDs Items are emails and attachments Emails have attachids listing each BatesStart of the attachments listed in attachment range Attachments have ParentIDs for the Email they belong to Some ParentIDs and AttachIDs are populated for your reference

I need a formula that sums a range of cells by comparing a single cell and the current date to a couple of other ranges.

Copy range only when cell is not empty, if empty do nothing. How do i do it in google spreadsheet?

Hi just looking for some conditional formatting excel 2010 help. I am looking for a way to highlight red a range of cells if they do not contain a formula