Hi All, I have attached an excel sheet. There are data in Sheet1 and Sheet2. * Every month there will be a new sheet1 with a new month. Currently have June in Sheet1. Next month August will be there. * Sheet1 have Customers and Amount under the Month column. * In sheet2 have all the customers and all the months of 2023. * Columns of sheet2 should be placed as it is after the output. * Next month when I will have data for August, then the amount should be filled in the sheet2 under August column. * Match the Parent Name between two sheets and put the amount from Sheet1 to Sheet2 under the specific month. * Looking for Dynamic resolution. Kindly help, how to do that? Test.xlsx

Match the Data and place the amount.

ArijitRoy

Hi All,

I have attached an excel sheet. There are data in Sheet1 and Sheet2.

Every month there will be a new sheet1 with a new month. Currently have June in Sheet1. Next month August will be there.
Sheet1 have Customers and Amount under the Month column.
In sheet2 have all the customers and all the months of 2023.
Columns of sheet2 should be placed as it is after the output.
Next month when I will have data for August, then the amount should be filled in the sheet2 under August column.
Match the Parent Name between two sheets and put the amount from Sheet1 to Sheet2 under the specific month.
Looking for Dynamic resolution.

Kindly help, how to do that?

Test.xlsx

Data Investigation

Accepted answers

binu_acs

@ArijitRoy I updated the workflow , can you check now

DynamicSelect_070623.yxzp

DynamicSelect_070623.yxmd

All comments

binu_acs

@ArijitRoy One way of doing this with the dynamic select tool

Note: all of sheet1 data is not matching with the Sheet2 parent names

DynamicSelect_070623.yxzp

DynamicSelect_070623.yxmd

ArijitRoy

Hi @binu_acs,

My apologies. I have to add those missing 13 lines at the end of the sheet2 and amount under June. Dynamically.

ArijitRoy

Hi @binu_acs,

Amounts are not under the same customer. Sheet1 customers value is on different customers under Sheet2.

binu_acs

@ArijitRoy @Can you give a sample amount which is not matching?

binu_acs

@ArijitRoy I updated the workflow , can you check now

DynamicSelect_070623.yxzp

DynamicSelect_070623.yxmd

geraldo

@ArijitRoy

An example workflow using excel's range generation.
As pointed out the sheets are not balanced on sheet1 and sheet2 there is information that you will not find.
I let it be inserted on sheet 2 without the parent name

MatchTheData.yxzp

binu_acs

@ArijitRoy Question, In the current month you are having June data, and next month you are expecting August Data, so then there will not be any July data?

ArijitRoy

Like we add the data of July from Sheet1 to Sheet2. Next month I am gone a have August's data in sheet1. Now sheet 2 is already gone a have June data so August's data should be added to Sheet2 under August '23. Likewise every month it should work like that. Next year, month will start from December '24 to December '23 on the sheet2.

binu_acs

@ArijitRoy Your Sheet1 had June data so I updated the workflow according to picking the June data in the dynamic select tool, If you are expecting this should be July then you need to adjust the formula in the dynamic select tool. Let me know if you need any assistance

ArijitRoy

Hi @binu_acs,

The sheet1 should have May data. I by mistake mentioned June. I am preparing this for previous month. I have updated the formula in the Dynamic Select tool as "DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"Month"),"%B '%y")" in all.

In the month of July, I will be preparing for June month and I hope tool will pick that. If not then please tell me what should I apply in the Dynamic Select.?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703