hola, hay algun codigo que me permita copiar los datos, pero que en la primera columna que son fechas puedan ser consecutivas.
ejemplo
en vez de que quede asi
10/01/2022 19.258.369-4 Juan Ramirez
10/01/2022 19.258.369-4 Juan Ramirez
10/01/2022 19.258.369-4 Juan Ramirez
quede asi
10/01/2022 19.258.369-4 Juan Ramirez
02/10/2022 19.258.369-4 Juan Ramirez
03/10/2022 19.258.369-4 Juan Ramirez
tengo una base de datos muy grande y debo hacer esto en el menor tiempo posible.
gracias
ejemplo
en vez de que quede asi
10/01/2022 19.258.369-4 Juan Ramirez
10/01/2022 19.258.369-4 Juan Ramirez
10/01/2022 19.258.369-4 Juan Ramirez
quede asi
10/01/2022 19.258.369-4 Juan Ramirez
02/10/2022 19.258.369-4 Juan Ramirez
03/10/2022 19.258.369-4 Juan Ramirez
tengo una base de datos muy grande y debo hacer esto en el menor tiempo posible.
gracias
Hi there,
Do you mean that anything else are the same but the date?
If so, you can enter 10/1/2022 in the first cell, say A1, and enter =A1+1 in the cell A2. Then copy and paste "19.258.369-4 Juan Ramirez" as many times as you want in the column next the the date column.
At last, double click on the fill handle in the bottom-right corner of the cell A2, so that the formula will automatically fill in the below cells.
If you want to combine the two columns, you can use Kutools for Excel's Combine Rows, Columns or Cells without Losing Data feature: https://www.extendoffice.com/product/kutools-for-excel/excel-combine-columns-rows.html
Amanda
Do you mean that anything else are the same but the date?
If so, you can enter 10/1/2022 in the first cell, say A1, and enter =A1+1 in the cell A2. Then copy and paste "19.258.369-4 Juan Ramirez" as many times as you want in the column next the the date column.
At last, double click on the fill handle in the bottom-right corner of the cell A2, so that the formula will automatically fill in the below cells.
If you want to combine the two columns, you can use Kutools for Excel's Combine Rows, Columns or Cells without Losing Data feature: https://www.extendoffice.com/product/kutools-for-excel/excel-combine-columns-rows.html
Amanda
- Page :
- 1
There are no replies made for this post yet.