# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I would need a formula what copies from my DataInput sheet into another one daily the first two column A and B.
Solved by B. C. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/07/2018 - 05:49
Welcome, Thanks for choosing Got It Pro-Excel.
User 23/07/2018 - 05:50
Here is my data in A and B
User 23/07/2018 - 05:51
I would need to transfer into a new sheet daily
Excelchat Expert 23/07/2018 - 05:52
Do you imply you will end up with so many sheets?
User 23/07/2018 - 05:53
I would need to transfer to a new sheet by the todays name of the sheet
User 23/07/2018 - 05:53
so daily would create a "history" of the products and batch numbers
User 23/07/2018 - 05:53
I show you what i mean
Excelchat Expert 23/07/2018 - 05:53
Okay.
User 23/07/2018 - 05:55
so daily creates a copy of the data input's A and B column into a new sheet
User 23/07/2018 - 05:55
and that sheet has the todays name
Excelchat Expert 23/07/2018 - 05:55
Nice one. I get you now.
Excelchat Expert 23/07/2018 - 05:56
This will need VBA to accomplish; functions alone they are inadequate.
User 23/07/2018 - 05:56
yes I know :)
User 23/07/2018 - 05:56
i m tottaly noob in vba
Excelchat Expert 23/07/2018 - 05:58
Okay.
Excelchat Expert 23/07/2018 - 05:59
A moment as I figure this out.
User 23/07/2018 - 05:59
Excelchat Expert 23/07/2018 - 06:11
I have created a sheet named "VBA code":
Excelchat Expert 23/07/2018 - 06:12
I have added code to it.
User 23/07/2018 - 06:12
this automatically creates a sheet daily with the A and B colum from the DataInput ? :O
Excelchat Expert 23/07/2018 - 06:13
The code will do that.
User 23/07/2018 - 06:14
and what if the sheet already exist ? it wont owerwrite the data ?
Excelchat Expert 23/07/2018 - 06:14
Copying column A and B is equally the same as creating a copy of the current sheet.
Excelchat Expert 23/07/2018 - 06:14
You indicated that the sheet should contain data for the current date.
User 23/07/2018 - 06:15
I mean it's time coded or I need to run the macro manually ?
User 23/07/2018 - 06:16
don't get me wrong Im a newbie into vba I see the active sheet range is B1. Iwhat that means ?
Excelchat Expert 23/07/2018 - 06:17
B1 simply represents the cell which will contain the current date.
User 23/07/2018 - 06:17
Oh I see :)
User 23/07/2018 - 06:17
i wanted to have the date as a sheet name
Excelchat Expert 23/07/2018 - 06:18
Yeah it will do that.
Excelchat Expert 23/07/2018 - 06:18
It is simple. Follow with me in the following steps.
User 23/07/2018 - 06:18
ok
User 23/07/2018 - 06:18
i watch
Excelchat Expert 23/07/2018 - 06:19
Open any workbook with data.
User 23/07/2018 - 06:19
ok
User 23/07/2018 - 06:19
opened
Excelchat Expert 23/07/2018 - 06:20
Rename the sheet whose data you want to be copied as "Template"
User 23/07/2018 - 06:20
ok
Excelchat Expert 23/07/2018 - 06:20
Press ALT + F11
User 23/07/2018 - 06:20
ok
User 23/07/2018 - 06:20
code view
Excelchat Expert 23/07/2018 - 06:21
Exactly
Excelchat Expert 23/07/2018 - 06:21
Go to Insert Menu > Module
User 23/07/2018 - 06:21
yeah it's done
User 23/07/2018 - 06:21
copied ur vba
Excelchat Expert 23/07/2018 - 06:21
Paste it
User 23/07/2018 - 06:21
done
Excelchat Expert 23/07/2018 - 06:22
Save the file
User 23/07/2018 - 06:22
oh I see
User 23/07/2018 - 06:22
so basically made a new sheet
User 23/07/2018 - 06:22
with the current date
User 23/07/2018 - 06:23
and I have all the data in it
User 23/07/2018 - 06:23
I have other datas in my template
User 23/07/2018 - 06:23
it is possible to copy only the A and B column ?
Excelchat Expert 23/07/2018 - 06:23
Okay.
User 23/07/2018 - 06:24
and also my question is that I would need to get only the data
User 23/07/2018 - 06:24
i mean value
User 23/07/2018 - 06:24
due I have formulas what I don't need
User 23/07/2018 - 06:25
It's interesting my Batching cell in B1 is renamed to the today's date...
Excelchat Expert 23/07/2018 - 06:26
What you will need is to allocate a blank cell which will contain current date.
Excelchat Expert 23/07/2018 - 06:27
In that cell which will contain current date you will enter the formula:
Excelchat Expert 23/07/2018 - 06:27
=TODAY()
Excelchat Expert 23/07/2018 - 06:27
It has not to be B1
Excelchat Expert 23/07/2018 - 06:27
Once you change it, also change the place where there is B1 to the cell address you changed to.
Excelchat Expert 23/07/2018 - 06:28
It will make the value of the date in the cell to be the name of the sheet.
User 23/07/2018 - 06:29
ok got it.
User 23/07/2018 - 06:29
how can I limit the copy area for only A and B column and only for values
User 23/07/2018 - 06:30
i think it's called only visible data
Excelchat Expert 23/07/2018 - 06:31
Okay. We simply edit the code.
User 23/07/2018 - 06:35
ok
Excelchat Expert 23/07/2018 - 06:42
I am doing the code which will copy only values without formulas and within the range you specified.
User 23/07/2018 - 06:43
quick question. does this site pays you at least ?
User 23/07/2018 - 06:43
I'm just feeling dump using the free extension ...
Excelchat Expert 23/07/2018 - 06:47
I am seeing the time is not enough.. I am at the last phase of the formula.
Excelchat Expert 23/07/2018 - 06:48
Kindly you can allow an extension so that I can be in a position to chat with you.
User 23/07/2018 - 06:48
ok
Excelchat Expert 23/07/2018 - 06:48
Thank you for understanding.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.