Expert with pivot tables, very good with many functions, excellent in report formatting. I don't do charts.
Heavy Excel user & SAS programmer since 1994. I don't do VBA code, but would like to learn.
Very user friendly software & simple to use.
|AAMIR||02/28/17||10||10||10||tried it the first row now becomes .....|
|Debbie||10/02/14||10||10||10||Thanks for getting back with me so .....|
|Karen||03/20/12||10||10||10||I tried to get answers from several .....|
|Karen||03/13/12||10||10||10||It's on my original thread: 6 column .....|
By changes if you mean you have the same number of columns, all you will need to do is refresh the table after you repopulate your data sheet. If your number columns change, you will need to reset the
It sounds like the log in screen is a form of security for the web page. There might be a VBA script you could use to entert the login on the web site, but I am not that well versed on VBA. Contact Aidan
Here's the table I got Count of SSN Date Name 5/15/2005 5/31/2005 6/15/2005 12/31/2005 1/15/2006 1/31/2006 2/15/2006 Grand Total John 1 1 1 1 4 Tim 1 1 1 3 Grand Total 1 1 1 1 1 1
Did you format the pivot table?
1. That would be a format. In the Format pull down menu select Format Cell. There are a variety of time formats you can chose. 2. To separate data in a cell you Text to Columns located in the Data
Answers by Expert: