# 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 K. S. in 33 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/07/2018 - 04:43
Hi
User 25/07/2018 - 04:43
Hey
User 25/07/2018 - 04:44
I would need a help with a VBA or similar what would copy my A and B column into a new sheet daily
Excelchat Expert 25/07/2018 - 04:45
In your description you mentioned the use of formula.. We do not support VBA
User 25/07/2018 - 04:45
I know.
Excelchat Expert 25/07/2018 - 04:45
Copying the first 2 columns into 20,07,18 is doable using formula
Excelchat Expert 25/07/2018 - 04:46
have other column in DataInput?
User 25/07/2018 - 04:46
yes
User 25/07/2018 - 04:46
I have
User 25/07/2018 - 04:46
that's why I need to copy only the 1st 2
Excelchat Expert 25/07/2018 - 04:46
will there be an criteria that you would consider while placing the data like date ?
User 25/07/2018 - 04:46
it's like a "report sheet"
User 25/07/2018 - 04:46
No criteria
User 25/07/2018 - 04:47
as you see now the 1st 2 column here
Excelchat Expert 25/07/2018 - 04:47
yes got it .. so anything in column A,B all needs to go to 25,07,18 right
User 25/07/2018 - 04:47
I would need that to copy the values daily into a new sheet
User 25/07/2018 - 04:47
yes exactly and that new sheet to have the todays name all the time.
User 25/07/2018 - 04:47
due my 1st 2 column is changing daily or ocassionally
Excelchat Expert 25/07/2018 - 04:48
ok formula ca not create a new sheet
Excelchat Expert 25/07/2018 - 04:48
oh so this is like keeping the historic data?
User 25/07/2018 - 04:48
exactly
Excelchat Expert 25/07/2018 - 04:48
hmmm
User 25/07/2018 - 04:49
I have that formula to make a new sheet
User 25/07/2018 - 04:49
Sub AddSheets_TodayDate() Dim szTodayDate As String szTodayDate = Format(Date, "dd.mm.yy") On Error GoTo MakeSheet Sheets(szTodayDate).Activate Exit Sub
Excelchat Expert 25/07/2018 - 04:50
I can build a genaric formula but you would have to create a new sheet with todays date and enter the formula every time..To do this autoomated you need a VBA
Excelchat Expert 25/07/2018 - 04:50
Yes that is a VBA
User 25/07/2018 - 04:50
yes I know I need a VBA
User 25/07/2018 - 04:50
i got help here for VBA
User 25/07/2018 - 04:50
just when I bought a new session it doesnt allowed the system to continue
Excelchat Expert 25/07/2018 - 04:50
Here as in in this site?
User 25/07/2018 - 04:50
diesconnected
User 25/07/2018 - 04:51
exactly
User 25/07/2018 - 04:51
here one of the expert built for me
User 25/07/2018 - 04:51
Excelchat Expert 25/07/2018 - 04:51
No we do not support VBA
User 25/07/2018 - 04:51
but the system fucked up and he couldn't finish
Excelchat Expert 25/07/2018 - 04:51
I am surprised that someone built it .. we would be in voilation..
User 25/07/2018 - 04:51
believe me
User 25/07/2018 - 04:52
User 25/07/2018 - 04:52
i wouldn't be here else
User 25/07/2018 - 04:52
but the customer care didn't refund me with the money on my paypal
Excelchat Expert 25/07/2018 - 04:52
if you are sure of that then please reach to the help center and ask them to reach out to the other expert to get you data
User 25/07/2018 - 04:52
he gave me a free session what wasn't i was looking for
User 25/07/2018 - 04:52
hy was anonymous something
User 25/07/2018 - 04:53
cheetah or whatever
Excelchat Expert 25/07/2018 - 04:53
Oh ok ask the customer care to reach to the expert and let him send the file again to you
User 25/07/2018 - 04:53
they can reach him ?
User 25/07/2018 - 04:53
without name ?
Excelchat Expert 25/07/2018 - 04:53
just mention the session details they would be able to track the expert
User 25/07/2018 - 04:54
okay. I try to . he was very helpful and he knew what he was doing
Excelchat Expert 25/07/2018 - 04:54
No actually not without name I'll try though.. but since VBA is not supported not sure if they would reply back..Actually with this violations we receive warnings
User 25/07/2018 - 04:54
but if he is able to build vba why it's not allowed?
Excelchat Expert 25/07/2018 - 04:54
That is the reason I am reluctant on writing the VBA code for you
User 25/07/2018 - 04:55
but you are able to write a vba ?
Excelchat Expert 25/07/2018 - 04:55
Because its the policy .I know VBA
User 25/07/2018 - 04:55
that 's just odd
Excelchat Expert 25/07/2018 - 04:55
But we cant share VBA files on this chat its blocked
User 25/07/2018 - 04:55
people would come here more offen and would pay
User 25/07/2018 - 04:56
no he didnt share in chat
User 25/07/2018 - 04:56
User 25/07/2018 - 04:56
and paste inside
Excelchat Expert 25/07/2018 - 04:56
Yes i know VBA is needed but not sure of the reson
User 25/07/2018 - 04:56
like I did now
Excelchat Expert 25/07/2018 - 04:56
yes that also we have received a recent warning stating that isn't doable ..
User 25/07/2018 - 04:57
gosh it's just unfair
User 25/07/2018 - 04:57
for people who pay
User 25/07/2018 - 04:57
cuz I know it's an easy vba what I need
Excelchat Expert 25/07/2018 - 04:57
Can you try to reach the customer care and ask them to reach the expert on your behalf and ask for the file
User 25/07/2018 - 04:57
but I can't put together 2 vba formula
User 25/07/2018 - 04:57
he wasn't able to finish
User 25/07/2018 - 04:58
User 25/07/2018 - 04:58
and my money wasn't actually refunded on my balance due was given a free session
User 25/07/2018 - 04:58
not I was looking for
User 25/07/2018 - 04:58
I replied them but no response
Excelchat Expert 25/07/2018 - 04:59
sorry to hear that ..
User 25/07/2018 - 04:59
yeah ...
User 25/07/2018 - 04:59
i tried to get help on excelforum and stackoverflow
User 25/07/2018 - 04:59
User 25/07/2018 - 05:00
over a week now
Excelchat Expert 25/07/2018 - 05:01
i'll send a mail to the support staff
User 25/07/2018 - 05:01
I would appreciate it.
User 25/07/2018 - 05:02
mail related to refund or what kind :)
User 25/07/2018 - 05:02
just to know what to wait for
Excelchat Expert 25/07/2018 - 05:02
refund i'm not sure ..I would just ask them to reach out to the previous expert to ask for the completed file i guess
User 25/07/2018 - 05:03
Basically what I need shortly cuz he was able to
User 25/07/2018 - 05:03
VBA what makes daily a copy from the A and B column and paste the values into a new sheet named by todays date
User 25/07/2018 - 05:04
I don't know if that can be automated somehow
User 25/07/2018 - 05:04
or this file needed to be opened daily
Excelchat Expert 25/07/2018 - 05:04
hmmm it would have to be opened .. how is DataInput getting updated?
User 25/07/2018 - 05:05
By the TODAY() command
User 25/07/2018 - 05:05
and of course if some things get changed
User 25/07/2018 - 05:05
due I want to do a batch coding system
User 25/07/2018 - 05:06
I have unique batch numbers what contains more batch numbers and then generates a new unique one from other 4
User 25/07/2018 - 05:06
so these won't update daily but the production date does
User 25/07/2018 - 05:06
let's say
User 25/07/2018 - 05:06
24123/25.07,18
User 25/07/2018 - 05:06
thats a batch number
User 25/07/2018 - 05:07
a unique one looks like Melons0002
User 25/07/2018 - 05:07
if one of the canteloupe , galia or watermelon batch changes
User 25/07/2018 - 05:07
then the Melons changes to 003
User 25/07/2018 - 05:07
Melons003/25.07.18
Excelchat Expert 25/07/2018 - 05:07
oh..
User 25/07/2018 - 05:08
but the todays date changes daily what obvious
Excelchat Expert 25/07/2018 - 05:08
VBA runs only when you open the file
User 25/07/2018 - 05:09
but it is possible to do something like if the current time is 1pm but the creation time of the report is 4pm then nothing changes
User 25/07/2018 - 05:09
if the current timie is 5 pm and the set time is 4 pm then a new sheets get created
Excelchat Expert 25/07/2018 - 05:09
Have sent the email the the support staff .Sorry but the site has strict policies and I do not want to be on the wrong side .
User 25/07/2018 - 05:09
I know what you mean
User 25/07/2018 - 05:09
I dont ask you for the code
Excelchat Expert 25/07/2018 - 05:09
yes you can chek date and time while you run the code
User 25/07/2018 - 05:09
I know u cant do that
User 25/07/2018 - 05:10
for an expert like you
Excelchat Expert 25/07/2018 - 05:10
Appreciate it..
User 25/07/2018 - 05:10
the code what I need all together how much times it takes to make it
User 25/07/2018 - 05:10
if I would like to "hire" somebody to make that vba
User 25/07/2018 - 05:10
I think it's a very basic one, not so many variable needed for it
Excelchat Expert 25/07/2018 - 05:10
may take 2-3 hours depending on the multiple criteiras you are mentioning
Excelchat Expert 25/07/2018 - 05:10
yes it is
Excelchat Expert 25/07/2018 - 05:11
it may not be very complex just moving the data across
User 25/07/2018 - 05:11
hmm.... without codes can u explain why
Excelchat Expert 25/07/2018 - 05:11
explain why it will take 2-3 hours?
User 25/07/2018 - 05:11
yeah
User 25/07/2018 - 05:12
due I 've seen codes very short one , what copied columns by button into a new sheet
User 25/07/2018 - 05:12
on the video by explaining that was 15 min with the tutorial
Excelchat Expert 25/07/2018 - 05:12
its a genaric time frame ... since once the code is written you would have to keep running it to see it it is all good . few back and forth corrections
User 25/07/2018 - 05:12
oh okay. sorry I was just curios
Excelchat Expert 25/07/2018 - 05:12
no issues ..
User 25/07/2018 - 05:13
for people who are expert it's not a big thing
Excelchat Expert 25/07/2018 - 05:13
I gave you the broder frame
User 25/07/2018 - 05:13
copy and paste 1st to column into a new sheet
User 25/07/2018 - 05:13
and rename the sheet by todays date
Excelchat Expert 25/07/2018 - 05:13
You will also need time to explain to the person and they would need time to explain solution back to you
Excelchat Expert 25/07/2018 - 05:14
yes if there is no other dependencies then may be can be done in 1 hr but testing would take time
Excelchat Expert 25/07/2018 - 05:14
just blind copy
User 25/07/2018 - 05:14
yeah
Excelchat Expert 25/07/2018 - 05:15
then 1 hour or less based on how good they are in VBA
User 25/07/2018 - 05:15
well then that's it.
User 25/07/2018 - 05:16
thanks for you time explaining the rules here
Excelchat Expert 25/07/2018 - 05:16
:) Have a nice day
User 25/07/2018 - 05:16
im unhappy but what I can do
User 25/07/2018 - 05:16
have a nice day. cheers.
Excelchat Expert 25/07/2018 - 05:16
Sorry you are still stuck with this
Excelchat Expert 25/07/2018 - 05:16
have a nice day

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.