Transfering data between sheets

  • Thread starter Thread starter Mahendra
  • Start date Start date
M

Mahendra

Hi! Here is a tough one to crack!
I want to transfer data from a particular cell in one sheet to a
particular cell in the new sheet which I start a week later. That
means- I need a function that will get data from the last sheet i.e.
(n-1) to nr. (n) sheet which I establish subsequently every week.Each
new sheet is numbered as (n+1)
Hope I have explained it such that you can understand my query!
 
Hi
This macro adds a sheet at the end of a workbook, then copies the valu
of cell A2 in the previously last sheet into cell A1 of the newly adde
sheet

Sub New_sheet()
n = Sheets.Count
Sheets.Add after:=Sheets(n)
Sheets(n + 1).Range("a1").Value = Sheets(n).Range("a2").Value
End Su
 

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

Relative transfer of data from the last sheet 2
VLOOKUP NOT RETURNING EXPECTED DATA 5
Calculate data from different sheets 4
auto creating an idex sheet when adding formatted sheets 15
clear all sheets code 4
Coloured Cells 8
Protect & Hide Sheet 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top