help with Excel VB-Run macro by condition Closed

Question

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!

kean · Accepted Answer

If you got any download material for "Creating a Macro in MS Excel Using MS Visual Basic",
 Could you please send it across? It would be really helpful for me.

Erica · Answer

It sounds to me like the easiest way to resolve this is just to add a new row at the top, and then check to make sure that all formulas conditional to the data include the new row.

Hope this helps,

Erica

giz · Answer

Google "Creating a Macro in MS Excel Using MS Visual Basic", its amazinf what you will find!

Help with Excel VB-Run macro by condition

3 responses

Similar discussions

Subscribe To Our Newsletter!