Hello all,
move reached a point where I’ve crashed Excel many times trying to accomplish what I think is an easy task:
I am trying to create a workbook with 3 sheets in order to cross reference and identify specific data in reference to a Query pull.
Sheet 1 - Blank entry table where 4 columns of data are entered.
Sheet 2 - Query Database Connection Pull
Sheet 3 - Auto-Populated row data (from sheet 2) based on duplicate values found within Column A of both sheet 1 and sheet 2.
Vlookup would be in place as well in order to migrate the additional column data from sheet 1 in reference to the value populated in sheet 3 column A.
i keep crashing excel and I don’t know why. I have not tried coding, because I’m not fluent with it. But apparently I’m not fluent with the other conditional formatting either.
in perspective- the query data is about 20k rows, I know that plays a part in the lag and crash.
any suggestions?
move reached a point where I’ve crashed Excel many times trying to accomplish what I think is an easy task:
I am trying to create a workbook with 3 sheets in order to cross reference and identify specific data in reference to a Query pull.
Sheet 1 - Blank entry table where 4 columns of data are entered.
Sheet 2 - Query Database Connection Pull
Sheet 3 - Auto-Populated row data (from sheet 2) based on duplicate values found within Column A of both sheet 1 and sheet 2.
Vlookup would be in place as well in order to migrate the additional column data from sheet 1 in reference to the value populated in sheet 3 column A.
i keep crashing excel and I don’t know why. I have not tried coding, because I’m not fluent with it. But apparently I’m not fluent with the other conditional formatting either.
in perspective- the query data is about 20k rows, I know that plays a part in the lag and crash.
any suggestions?