i currently use macros to change some downloaded sales information.
unfortunately, the volume always changes and I cannot use a macro for
creaqting a Pivot table. When i select cell A1 and hit pivot tabel it
automatically selcts the range. In my macro it will only select the actual
range i recorded. IS there a way to go around that?

Thanks
Mike