Hi All:
I would like to automate some of my Excel sheets. I have two: in one I have the data with colors and a nice design; in the other I have the raw data.
I want to be able to populate on the “Tickets” sheet breached and warning tickets only and include five specific columns from the Raw - Incident Request report sheet.
This is how the code looks right now in the Ticket sheet:
For status Column: +'Raw - Incident Request Report'!AC7
For priority =+'Raw - Incident Request Report'!D7
For MA: =+'Raw - Incident Request Report'!I7
etc…..
I'm not using any logic (I tried though and it looked like this =IF('Raw - Incident Request Report'!AC7="Breached", "Breached", "") but I was not able to do that with the other rows because they change content every time the raw sheet is updated, so I erased it). It is only calling that specific column and I used conditional formatting to color breached and warning. Now, I only want breached and warning tickets to show up and no 0 numbers nor blank raws. Also, the raw sheet gets replaced with new information every day. So if there is a new row in the raw sheet and I haven’t included it in the “ticket” sheet everything will turn into 0.
I only want to get the breached/warning ticket and four other rows: Priority/MA/Title/Assigned To.
I looked at this thread http://www.excelforum.com/excel-gene...her-sheet.html and the user was able to accomplish it. I tried changing the VBA to my needs but it did not work.
Thank you all in advance
Bookmarks