In columns C and D of my spreadsheet of car brands I have to enter brands, such as:
Column C Column D
BMW VOLVO
AUDI FIAT
VOLKSWAGEN RENAULT
PEUGEOT ALFA ROMEO
My data are such that some combinations, for instance BMW & VOLVO and VOLKSWAGEN & RENAULT have to be filled in much more often than for instance AUDI & FIAT or PEUGEOT & ALFA ROMEO.
Is it possible to enter the frequent combinations BMW & VOLVO and VOLKSWAGEN & RENAULT in a fast way? I would like to avoid having to cut and paste the combination BMW & VOLVO from A1 and B1 (which contain these brands) and paste it in C1 and D1, then to cut and paste VOLKSWAGEN & RENAULT from A2 and B2, paste it in C2 and D2, then back again to A1 and B1, etc.
Is it possible to use VBA-code assigned to shortcuts for this? For instance: Ctrl+a is Cut the contents from A1 and B1 and paste it from active cell C[n] into C[n] *and* D[n}, Ctrl+b is Cut the contents from A2 and B2 and paste it from active cell C[n] into C[n] *and* D[n}? Would it be possible maybe by first CONCATENATING the contents of A1 and B1 in another cell, for instance (F[n]), and then DE-CONCATENATE the CONCATENATED brandnames (BMWVOLVO, VOLKSWAGENRENAULT) and place the two different brand names (BMW and VOLVO) in C[n] and D[n]?
Thanks in advance,
JohanXL
Column C Column D
BMW VOLVO
AUDI FIAT
VOLKSWAGEN RENAULT
PEUGEOT ALFA ROMEO
My data are such that some combinations, for instance BMW & VOLVO and VOLKSWAGEN & RENAULT have to be filled in much more often than for instance AUDI & FIAT or PEUGEOT & ALFA ROMEO.
Is it possible to enter the frequent combinations BMW & VOLVO and VOLKSWAGEN & RENAULT in a fast way? I would like to avoid having to cut and paste the combination BMW & VOLVO from A1 and B1 (which contain these brands) and paste it in C1 and D1, then to cut and paste VOLKSWAGEN & RENAULT from A2 and B2, paste it in C2 and D2, then back again to A1 and B1, etc.
Is it possible to use VBA-code assigned to shortcuts for this? For instance: Ctrl+a is Cut the contents from A1 and B1 and paste it from active cell C[n] into C[n] *and* D[n}, Ctrl+b is Cut the contents from A2 and B2 and paste it from active cell C[n] into C[n] *and* D[n}? Would it be possible maybe by first CONCATENATING the contents of A1 and B1 in another cell, for instance (F[n]), and then DE-CONCATENATE the CONCATENATED brandnames (BMWVOLVO, VOLKSWAGENRENAULT) and place the two different brand names (BMW and VOLVO) in C[n] and D[n]?
Thanks in advance,
JohanXL