I want to scrape the A and B values from the website and input them based on the date.
ex)) If you run it on 1/14
“1/14/2025” row - “Same day” AB column - A:10 B:20
Same day + 1 day “1/15/2025 row” “1 day ago” column A:20 B:30
Same day + 2 days “1/16/2025 row” “2 days ago” column A:30 B:40
I want to input it sequentially like this…
“날짜”=“date” “요일”=“week” “당일=now today” “1일 전” = “today-1” “2일 전” = “today-2”····
New users cannot upload, so I couldn’t upload the Excel file. It’s in the format shown in the image above.
I need help please help me
I will wait for your advice
thank you
The first row is a merged cell, and the A and B values below it need to be found separately. The cells that meet the two conditions need to be found. I couldn’t solve this method. ToT
If there is a good method or another groundbreaking method, please give me some advice.