Hi all,
I think I'm overthinking this for certain, but could use some help.
I have an Excel Workbook that contains a number of worksheets related to specialorders that I am required to place, progress and track through to receipt. The sheetsare named as follows Demands, Cleared, Cancelled and Hastening. The Demandsand Hastening sheets are the only ones that Im needing for this function, Demandscontains a plethora of information about each and every outstanding specialdemand I have on my system, currently there are about 30, but this fluctuatesweekly, the Hastening sheet is a PivotTable showing the most important data togive a brief overview of the demands outstanding.
I am looking tointroduce a new Hastening function that would,
I think I'm overthinking this for certain, but could use some help.
I have an Excel Workbook that contains a number of worksheets related to specialorders that I am required to place, progress and track through to receipt. The sheetsare named as follows Demands, Cleared, Cancelled and Hastening. The Demandsand Hastening sheets are the only ones that Im needing for this function, Demandscontains a plethora of information about each and every outstanding specialdemand I have on my system, currently there are about 30, but this fluctuatesweekly, the Hastening sheet is a PivotTable showing the most important data togive a brief overview of the demands outstanding.
I am looking tointroduce a new Hastening function that would,
- Copy all data contained on the PivotTable (Hastening) andsend it via email to Head Office
and then
- Insert the text Hastened by (username) on (system date)in Column AE and also place todays date in AF of the Demands sheet forall rows to show that that line has been progressed and on what date.
Ive managed toget part 1 sorted and working, but it is part 2 is where Im falling over.
My problem isthat for part 2, the new text entry must not overwrite any textcontained within cell AE already.
Can anyone helpor point me into the direction of success please??