Hi, good evening everyone.
I would like to ask question that I've been stuck for a very long time, so I made a decision to ask in this forum.
Roughly, I have TWO(2) worksheets. One sheet is Onhand, another sheet is input.
This is table for sheet Onhand,
someone can help me? It's a little bigger thing, let me describe the problem. Need to write macro which will be changing data source for 10 pivots in 10 different sheets. The data source and range will be same for all pivots. I just need the body of macro, dont need the procedures which...
I am creating a workbook for asset history where each asset has its own worksheet. This is continually updated as assets are utilized.<o:p></o:p>
For of data entry I would like to have a single input table where usage and values on multiple assets can be entered. I am looking for a VBA code...
I have a workbook with many sheets one of the sheets is a Pivot Table. I would like to give the user the option to create a new sheet with the pivot table sheet and the sheet that contains its source data only.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>...
I have the code below almost finished (there are 2 macros the first one , Macro4, does the charting perfectly in sheet1) and the second macro, Macro 5, makes the macro 4 repeat itself in each sheet of my workbook except for the first sheet.
However when I attempted to run the macro 5 I...