Search results

I have a pivot table that includes data using Months of the year in the Column Labels. I was using MONTH(A2) where A2 is an entered date, which returns the numbers 1-12. In my pivot table, I wanted it to say the name of the month. I did a lookup to retrieve the corresponding month name. Simple...

I was able to get my Dynamic Named Range table set up. I tried to reference the range in my Pivot Table. Under the Pivot Table Tab I clicked change source and a box came up asking for a table or range. I typed my named range right in the location field. My Pivot Table went blank So I tried...

In excel i have a sheet1 with data. I have a pivot table in sheet2 using that data from sheet1 I go back and add rows of data to sheet1. I manually go to the Pivot Table tab at the top -> click the options button -> click refresh. The newly added data to sheet1 does not appear. The only way...

Hello, I'm trying to record a macro that runs a macro. I have two sheets in my workbook. I'm on sheet 1 and move to recordedPositions. The I want the macro to run. I can manually go to sheet recordedPositions cell A4 and then manually run the macro and it all works fine. I want a one click...

Hello Everyone I'm Lobop3 and I'm pretty new to all this. My concentration will be using Excel.:)