Sample macro on how to rename a sheet based on file's created

phoenix0315

New Member
Joined
Nov 1, 2011
Messages
6
Hello,

Newbie here,

Anybody here have time to help me for excel VBA.
Please help me on about excel vba.
I have an excel file with one sheet named master and i would like to copy the master sheet to a new sheet and rename it as master rev.0 then if i have a latest data on master sheet, the data from master sheet on columnA will compare to the previous sheet ( master rev.0) then if there is a same data from master sheet and previou rev. in columnA,the data from column B to E of master rev.0. will automatically copy to the columnA of Master sheet.

Let say:
Master sheet
Col A Col B Col C Col D Col E
b
c
f
g
h
z
t

Master Rev.0
Col A Col B Col C Col D Col E
b 35 3 6 9
c 5 4
f
g 6 2
h 3 2 45 3

Result:
Master sheet
Col A Col B Col C Col D Col E
b 35 3 6 9
c 5 4
f
g 6 2
h 3 2 45 3
z
t
Then again ,if there is another latest data ,the on master sheet will be copy to another sheet then it will rename as MAster Rev.1, same procedure the latest rev will compare again to the previous rev. now it is Master rev1.

Thank you.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

GTO

MrExcel MVP
Joined
Dec 9, 2008
Messages
6,154
Greetings,

Maybe just me, but I am not following your question. It sounds as if you have it well thought through. It might help if you were to layout sample data using one of these:

To post sample data:
Excel Jeanie
Or
TO CONTACT RICHARD
Richard Schollar's HTML Maker
OR TO DOWNLOAD EITHER HTMLMaker (Richard's table maker) or VBHTMLMAKER (code) IN OLDER BROWSER
https://skydrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189&brby=1

Or
Borders;Copy;Paste

And maybe restate the question.

Cheers,

Mark
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,720
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top