Hello,I am defenetly not proffesional with VB!!!At the moment i am dealing with Excel 2003 for calculating a simple table of a small store.Finaly it comes that i NEED to record the last 20 dates of outgoing stuff.Up to me should look like this:
Worksheets("Sheet1").Activate
If ("G12") = True Then
Range("I12:I22").Select
Selection.Cut Destination:=Range("I13:I23")
Range("H12").Select
Selection.Cut Destination:=Range("I12")
Range("I12").Select
End If
In the end i need to move the whole list of 20 dates 1 row down and to place the new date in the top cell wich remein empty after the moving.Sounds simple and maybe you will lought but my head exploaded of this.
I will appriciate ANY helpfull advices and please excuse my english...I am from Bulgaria and i am verry tired.
Thanks in advance and GOOD LUCK!
Configuration: Windows XP Firefox 2.0.0.17
Excel copy data from one sheet to another if matches condition Excel hide rows macro Excel macro conditional format cell value Excel macro range Excel pop up macro if value Excel show comment macro Excel to access macro Excel vb if changed Excel vb macro load a file into a worksheet Excel vba move macro Excel vba run windows application How do you reate an excel macro to change colors for dates How to compare cells text with common on excel vb Microsoft word create a button to run macro Open outlook from excel and run outlook macro Run macro automatically in excel Vb for conditional formatting in excel example Vb script macro get last row