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
take your time
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.
