Transfer from 1 page to another

J

JOEE1979

Active Member
Joined
Dec 18, 2022
Messages
250
Office Version
  1. 365
Platform
  1. Windows
How would I take The info from (2024!B1564) and insert it into (Current Month (2)!N5)?
Keep in mind the Month/date will change every month.
I tried to do =Lookup but keep screwing up the formula, not sure if I should be using =Lookup or not.

Thank you


schedule 4 tracker.xlsx
ABCDEGH
15641-Mar-2424461-Mar-24
156583471-Mar-24
156683621-Mar-24
156784651-Mar-24
156885181-Mar-24
156901-Mar-24
157001-Mar-24
157101-Mar-24
157201-Mar-24
157301-Mar-24
157401-Mar-24
157501-Mar-24
157601-Mar-24
157701-Mar-24
157801-Mar-24
157901-Mar-24
158001-Mar-24
158101-Mar-24
158201-Mar-24
158301-Mar-24
158401-Mar-24
158501-Mar-24
158601-Mar-24
158701-Mar-24
158801-Mar-24
158901-Mar-24
2024
Cell Formulas
RangeFormula
B1564:B1589B1564=(B784)
H1564H1564=A1564
H1565H1565=A1564
H1566H1566=A1564
H1567H1567=A1564
H1568H1568=A1564
H1569H1569=A1564
H1570H1570=A1564
H1571H1571=A1564
H1572H1572=A1564
H1573H1573=A1564
H1574H1574=A1564
H1575H1575=A1564
H1576H1576=A1564
H1577H1577=A1564
H1578H1578=A1564
H1579H1579=A1564
H1580H1580=A1564
H1581H1581=A1564
H1582H1582=A1564
H1583H1583=A1564
H1584H1584=A1564
H1585H1585=A1564
H1586H1586=A1564
H1587H1587=A1564
H1588H1588=A1564
H1589H1589=A1564
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B56:B9519Expression=AND($M$2=H56, (ISBLANK(J56)))textNO
B56:B9519Expression=AND($M$2>H56, (ISBLANK(J56)))textNO
B56:B9519Expression=AND($M$2>H56, NOT(ISBLANK(J56)))textNO
C70:G81,C96:G107,C122:G133,C148:G159,C174:G185,C200:G211,C226:G237,C252:G263,C278:G289,C304:G315,C330:G341,C356:G367,C382:G393,C408:G419,C434:G445,C460:G471,C486:G497,C512:G523,C538:G549,C564:G575,C590:G601,C616:G627,C642:G653,C668:G679,C694:G705,C720:G731Other TypeIcon setNO
C56:G69,C82:G95,C108:G121,C134:G147,C160:G173,C186:G199,C212:G225,C238:G251,C264:G277,C290:G303,C316:G329,C342:G355,C368:G381,C394:G407,C420:G433,C446:G459,C472:G485,C498:G511,C524:G537,C550:G563,C576:G589,C602:G615,C628:G641,C654:G667,C680:G693,C706:G719Other TypeIcon setNO
A4,A30,A56,A108,A160,A212,A264,A316,A368,A420,A472,A524,A576,A628,A680,A732,A784,A836,A888,A940,A992,A1044,A1096,A1148,A1200,A1252,A1304,A1356,A1408,A1460,A1512,A1564,A1616,A1668,A1720,A1772,A1824,A1876,A1928,A1980,A2032,A2084,A2136,A2188,A2240,A2292,A2344Expression=($M$2=A4)textNO



schedule 4 tracker.xlsx
CDEFGHIJKLMNOP
2March 2024
3SundayMondayTuesdayWednesdayThursdayFridaySaturday
4252627282912
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Current Month (2)
Cell Formulas
RangeFormula
C2C2=DATE('Calendar Master'!P8,'Calendar Master'!P10,1)
C3,E3,G3,I3,K3,M3,O3C3=C4
C4C4=$C$2-(WEEKDAY($C$2,1)-(start_day-1))-IF((WEEKDAY($C$2,1)-(start_day-1))<=0,7,0)+1
E4,G4,I4,K4,M4,O4E4=C4+1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
P5:P21Expression=O5>0textNO
P5:P21Expression=AND(NOT(ISBLANK(P5)),AND((TODAY())>O$4,(ISBLANK(O5))))textNO
O20:O21Other TypeIcon setNO
O20:O21Expression=MONTH(O20)<>MONTH($C$2)textNO
O20:O21Expression=OR(WEEKDAY(O20,1)=1,WEEKDAY(O20,1)=7)textNO
O5:O19Other TypeIcon setNO
O5:O19Expression=MONTH(O5)<>MONTH($C$2)textNO
O5:O19Expression=OR(WEEKDAY(O5,1)=1,WEEKDAY(O5,1)=7)textNO
N5:N21Expression=M5>0textNO
N5:N21Expression=AND(NOT(ISBLANK(N5)),AND((TODAY())>M$4,(ISBLANK(M5))))textNO
M20:M21Other TypeIcon setNO
M20:M21Expression=MONTH(M20)<>MONTH($C$2)textNO
M20:M21Expression=OR(WEEKDAY(M20,1)=1,WEEKDAY(M20,1)=7)textNO
M5:M19Other TypeIcon setNO
M5:M19Expression=MONTH(M5)<>MONTH($C$2)textNO
M5:M19Expression=OR(WEEKDAY(M5,1)=1,WEEKDAY(M5,1)=7)textNO
L5:L21Expression=K5>0textNO
L5:L21Expression=AND(NOT(ISBLANK(L5)),AND((TODAY())>K$4,(ISBLANK(K5))))textNO
K20:K21Other TypeIcon setNO
K20:K21Expression=MONTH(K20)<>MONTH($C$2)textNO
K20:K21Expression=OR(WEEKDAY(K20,1)=1,WEEKDAY(K20,1)=7)textNO
K5:K19Other TypeIcon setNO
K5:K19Expression=MONTH(K5)<>MONTH($C$2)textNO
K5:K19Expression=OR(WEEKDAY(K5,1)=1,WEEKDAY(K5,1)=7)textNO
J5:J21Expression=I5>0textNO
J5:J21Expression=AND(NOT(ISBLANK(J5)),AND((TODAY())>I$4,(ISBLANK(I5))))textNO
I20:I21Other TypeIcon setNO
I20:I21Expression=MONTH(I20)<>MONTH($C$2)textNO
I20:I21Expression=OR(WEEKDAY(I20,1)=1,WEEKDAY(I20,1)=7)textNO
I5:I19Other TypeIcon setNO
I5:I19Expression=MONTH(I5)<>MONTH($C$2)textNO
I5:I19Expression=OR(WEEKDAY(I5,1)=1,WEEKDAY(I5,1)=7)textNO
H5:H21Expression=G5>0textNO
H5:H21Expression=AND(NOT(ISBLANK(H5)),AND((TODAY())>G$4,(ISBLANK(G5))))textNO
G20:G21Other TypeIcon setNO
G20:G21Expression=MONTH(G20)<>MONTH($C$2)textNO
G20:G21Expression=OR(WEEKDAY(G20,1)=1,WEEKDAY(G20,1)=7)textNO
G5:G19Other TypeIcon setNO
G5:G19Expression=MONTH(G5)<>MONTH($C$2)textNO
G5:G19Expression=OR(WEEKDAY(G5,1)=1,WEEKDAY(G5,1)=7)textNO
F5:F21Expression=E5>0textNO
F5:F21Expression=AND(NOT(ISBLANK(F5)),AND((TODAY())>E$4,(ISBLANK(E5))))textNO
E20:E21Other TypeIcon setNO
E20:E21Expression=MONTH(E20)<>MONTH($C$2)textNO
E20:E21Expression=OR(WEEKDAY(E20,1)=1,WEEKDAY(E20,1)=7)textNO
E5:E19Other TypeIcon setNO
E5:E19Expression=MONTH(E5)<>MONTH($C$2)textNO
E5:E19Expression=OR(WEEKDAY(E5,1)=1,WEEKDAY(E5,1)=7)textNO
D5:D21Expression=C5>0textNO
D5:D21Expression=AND(NOT(ISBLANK(D5)),AND((TODAY())>C$4,(ISBLANK(C5))))textNO
C20:C21Other TypeIcon setNO
C20:C21Expression=MONTH(C20)<>MONTH($C$2)textNO
C20:C21Expression=OR(WEEKDAY(C20,1)=1,WEEKDAY(C20,1)=7)textNO
C5:C19Other TypeIcon setNO
C5:C19Expression=MONTH(C5)<>MONTH($C$2)textNO
C5:C19Expression=OR(WEEKDAY(C5,1)=1,WEEKDAY(C5,1)=7)textNO
C4,E4,G4,I4,O4,C22,E22,G22,I22,K22,O22,C40,E40,G40,I40,K40,O40,C58,E58,G58,I58,K58,O58,C76,E76,G76,I76,K76,M76,O76,K4,C94,M4,M22,M40,M58Expression=MONTH(C4)<>MONTH($C$2)textNO
C4,E4,G4,I4,O4,C22,E22,G22,I22,K22,O22,C40,E40,G40,I40,K40,O40,C58,E58,G58,I58,K58,O58,C76,E76,G76,I76,K76,M76,O76,K4,C94,M4,M22,M40,M58Expression=OR(WEEKDAY(C4,1)=1,WEEKDAY(C4,1)=7)textNO
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
Hi Joee1979, so you want the value in cell B1564 to show up in cell N5? What about cell B1565, B1566, and so forth? does anything need to be done with those other cells in March 1st? Can you fill out an example with March 1st, March 2nd, March 3rd filled up in sheet CurrentMonth(2)? I think VLookup or Index(Match is the way to go, but in order to use it, you need to manipulate the data in your free columns, and I would use a count function to make each row unique in 2024, but that means both sheets have to have a unique identifier. Anyway, if you can post 3 days of sample data for 2024, and how it should appear in CurrentMonth(2), that would make the analysis easier. cheers!
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
conditional format to change color
2
Replies
10
Views
222
SanjayGMusafir
SanjayGMusafir
K
  • Solved
Help with Random Formulas
2
Replies
10
Views
1K
SanjayGMusafir
SanjayGMusafir
Agnarr
  • Question
From Conditional Formatting to VBA
Replies
1
Views
339
Peter_SSs
Peter_SSs
ricafonyat
  • Solved
Loans Payments Consolidated Cash Flow
Replies
1
Views
241
DRSteele
DRSteele
S
  • Question
Help with VB code to copy some values from one sheet to another
Replies
0
Views
835
skeeeter56
S

Forum statistics

Threads
1,215,096
Messages
6,123,074
Members
449,093
Latest member
ripvw

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