Excel VBA if "x", then select rows and paste to another sheet -
I am trying to develop a fundamental accounting spreadsheet for a work project. I'm not sure how to add attachments here, so I will try to explain it best.
Every day, I manually enter data in a sheet with multiple columns, examples of some of my column headings are: tax invoice number
, customer < / Code>,
details
, and date
. Ranging from A3
to Y3
to the range covering the range covering
to set me up Need is a front page report for others to easily read data, but who also allows me to populate: either current month results
or previous month results
or Year-by-date results
, whatever I choose, I know that many men Al ways, but I hope to give some feedback over this people!
Do anyone have any ideas? There is no need for VBA to merge data into a pivot table (hide the sheet)
Use and use the GetPivotData function to pull the exact fields if you need more customization ... The GetPivotData function will allow the viewer to filter out the external cells ... such use Can choose a combobox, list or a place for you The data verification ...
Comments
Post a Comment