Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 15 November 2022
  1 Replies
  1.1K Visits
0
Votes
Undo
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
2 months ago
·
#3208
0
Votes
Undo
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.
continues date.gif

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
Attachments (1)
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL