Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Create new worksheet & copy the based on date [Solved/Closed]

Report
-
 Raja -
Hello,
Can any one help me to copy the excel sheet data from one sheet to another sheet?

-> I have one excel sheet (name: Test.xls, sheet name: SHEET1)

Sn Code Type next calib
5 BPR CORR 7-Apr-12
4 BPR CORR 7-Apr-12
73 BPR CORR 7-Apr-12
9 BRG CORR 8-Apr-12
10 BRG CORR 8-Apr-12
11 BRG CORR 8-Apr-12
17 BRG CORR 9-Apr-12
311 DP CORR 9-Apr-12
227 DP CORR 9-Apr-12
227 DP CORI R 9-Apr-12

Want to create a new work sheet and copy the today's date(next calib - filed name) records to new sheet.

Example: Today's Date is 8-Apr-12
So, I want to copy following record to new work sheet (when I click the button / run the macro).

Sn Code Type next calib
9 BRG CORR 8-Apr-12
10 BRG CORR 8-Apr-12
11 BRG CORR 8-Apr-12

Please help to write the code.
Thanks!

See more

1 reply

Answer 1 / 1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 760
Start macro recorder
Apply the filter for date
copy the visible rows
paste
stop the recorder

this will give you a good template to work from
Thank you
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

View all 16 comments
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 760
One thing you need to correct is "K" and 12 part

both refers to the column on which you want to apply filter. Since you said , next calibration date, "K" should have been "L"
Report

Thanks a lot!

Now code is working as expected

Thanks again!
Report

Hi, I want to Learn more regrading the macros... Can you please share some links for learn excel macros
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 760
There should be some sites for that.
I find excel macro recorder is the best. It gives you a good template to start from, Plus if you study and try to understand that code, you learn too.

http://office.microsoft.com/en-gb/training/overview-RZ001150634.aspx?section=1
https://www.excel-easy.com/vba.html
Report

Thanks a lot :-)
Ask a question