Jan-05-2021, 08:56 PM
(Jan-05-2021, 06:34 PM)buran Wrote:(Jan-05-2021, 05:49 PM)SunWers Wrote: What would I be doing wrong?Isn't it obvious from the traceback?
ws2['C4']
is a cell object and you try to iterate over it, which is not possible.
I must be misunderstanding somewhere... I'm trying to filter through cells B2-B100 (Dates) on ws1 for matches for C4 (Date) on ws2. Once it finds the matches, then I wanted it to write the data from each row to ws3 starting at row 8. For the TypeError: "object is not iterable", does this mean it cannot be called? If so, is it where I created the data through a different script earlier and saved it to this excel file?
So Sorry... I'm trying to understand.