MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

using macro to insert values

  Asked By: Raju    Date: Mar 19    Category: MS Office    Views: 2330

How are you

My question is regarding “how to insert / copy a row from one xls file to
another through macro”

The problem which I am facing is!

1) create above macro
2) inserting a new row!, because there are few formulas on top all sheets
& if I add new row all the formulas will be disturbed, so the macro should
select Rows from A3 to E3
3) I want to only add 3 files through Marco, a)date from that file,
b)current index c) current rate of that particular script of company
4) The source file is 8-may-07 & targeted file is sharefile

Can any one help me



1 Answer Found

Answer #1    Answered By: Haboos Kauser     Answered On: Mar 19

The best way to start learning VBA is to record a macro  doing what you want to
do, then look at the macro and understand what it is doing.

Then you try changing something and run the macro to see what it does.

Do this and then see if the macro achieves what you want. Come back to the
list with specific problems if it does not.

Didn't find what you were looking for? Find more on using macro to insert values Or get search suggestion and latest updates.