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
he was almost ready
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
he made it
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
he made a new sheet
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
hang up on buying session
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
but no help received yet
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.