Add a column with custom cell values

[SriDurga]

Book1
	A	B	C
1	Id	Date	Week
2	af	2-Nov	Wk45
3	bd	2-Nov	Wk45
4	rg	2-Nov	Wk45
5	cv	2-Nov	Wk45
6	th	2-Nov	Wk45
7	drg	2-Nov	Wk45
8	dfg	2-Nov	Wk45
9	ytu	2-Nov	Wk45
10	sd	2-Nov	Wk45
11	utj	2-Nov	Wk45
12	4et	2-Nov	Wk45
13	j5	2-Nov	Wk45
14	5yt	2-Nov	Wk45
15	egjt	2-Nov	Wk45
16	reth	2-Nov	Wk45
17	dg5	2-Nov	Wk45
Sheet1

Hello all,
I need to add a column named "Week" basis the file name "Wk45", kindly help me with VBA logic to add the column "Week" and cell values basis the file name "Wk45".

 

[arthurbr]

Try =""Wk"&WEEKNUM(C2) and pull down.
( This supposes your week begins on Sunday)
See WEEKNUM function - Microsoft Support for syntax
If you need the ISO week number there is also a function for that

 

[SriDurga]

Try =""Wk"&WEEKNUM(C2) and pull down.
( This supposes your week begins on Sunday)
See WEEKNUM function - Microsoft Support for syntax
If you need the ISO week number there is also a function for that

Hi, I need VBA for the same, as I need to merge multiple files, would need the last column to be the name of the file while merging different files.

 

[arthurbr]

In the future, please add ALL your requirements from the start, to avoid wasting my time. Thx
(and some recognition for the provided help won't hurt either)

 

[SriDurga]

In the future, please add ALL your requirements from the start, to avoid wasting my time. Thx
(and some recognition for the provided help won't hurt either)

Thank you and apologies for wasting your time.

 

[arthurbr]

You're welcome