Copying data from another worksheet

V

Vincent88

Active Member
Joined
Mar 5, 2021
Messages
382
Office Version
  1. 2019
Platform
  1. Windows
  2. Mobile
Hi Everybody, I want to copy the data from same workbook (for Staff roster purpose) with worksheet ( sheetname is yyyymm like 202106 ) to another sheet ( 202107 ) based on the name in column A and date in row 2. See pictures. Both worksheets have table data range from Column A to Column AL.
Need to copy for example - Ben's last 5 days value of June in sheet 202106 to new sheet (202107) of that 5 days in column C to G.
How to use index, match or countif functions to get this job done in vba.
 

Attachments

  • NewSheetOlddays.png
    NewSheetOlddays.png
    15.7 KB · Views: 5
  • Prevmonth rows.png
    Prevmonth rows.png
    38.9 KB · Views: 5

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You must log in or register to reply here.

Similar threads

A
  • Question
Copy & Paste from workbook to another with criterias
Replies
2
Views
148
Anthony86
A
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
268
Insurance Dave
I
M
  • Question
Automatically Move Row to Another Sheet Based On Cell Value
Replies
6
Views
858
felixstraube
F
E
  • Question
Copy data from a Data Entry form's table to the correct date in another tab
Replies
0
Views
95
Exceleration65
E
tabbytomo
  • Solved
Copy entire row if cell has specific value, looking at multiple columns and worksheets.
Replies
2
Views
318
NateSC
NateSC

Forum statistics

Threads
1,215,218
Messages
6,123,676
Members
449,116
Latest member
HypnoFant

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top