I wish automate a cut and paste of data from one work book to ano

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need monthly to insert new budgets into column and over write the last
month's budgets. I would like a formular or macro to do this can you help
please?
 
Is the "*copy from*" column always the same from month to month?
Is the "-paste to-" column always the same from month to month?

Do the names of the work*books* change from month to month?
Do the names of the work-sheets- change from month to month?
 
The copy from column moves along each month for each monthly budget as the
budgets change each month.

The paste is the same every month.
The work book name stays the same each monthas does the work sheet.

I'm importing data to say cell1A and then using that data form my spread
sheet what ineed to do is comapre that data with that months budget. I have
the variances set up its just wanting automate the moving along one month and
if possible add one month to the othe to give a cumulative year to date #.
Would it help if I sen the spread sheet to you?

Many thanks for your help.

Ian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automate a cut and paste of data from one work book to another 2
determine a range using a formula 2
Return Value from a Range (depends on input to determind month) 2
Extracting cells from a table 6
How do i distribute columns of data to separate sheets? 1
automated cut and paste using regex 2
Prevent Cut and Paste 3
Pivot Tables: Don't show data for detail, but still show subtotals 3

Back
Top