Windows 10: Excel Macro - How to get current date in a column till Last row

Hi! I am new to Macros and am trying to get the current date automatically in the column “X” static date, not only in cell “X2” but in each cell until last row. Can you help me? Thank you so much in advance!Ginette

:)

 

Excel - date range column heading

Either of these

• COLUMNS($A$1:A1)-1
  
• ROWS($A$1:A1)-1
  

... will give you an increasing number for either COLUMNS or ROWS. The dual reference to A1 could be anywhere (e.g. on the current sheet) as long as it doesn't step out of the sheet when you copy the formula.

I believe the rest of the formula is pretty "standard".

 

Convert one column into a new column every 10 rows in Excel

I have a set of 110 numbers in Excel. I want to split this into 11 columns of 10 rows each.

So, for column:

I want the output to be:

What I've tried so far

1. Assigned =A11 in B1, =A21 in C1, =A31 in D1 and then used the autofill. However, this gives the formula =D11 in E1 and hence doesn't work.
   
2. Using Text to Columns wizard. This only provides for splitting of data for delimiter and there is now way of splitting based on number of rows.
   

The most similar question I've found is here where the goal is the opposite of mine (combining multiple columns into a single one).

This and this solve a similar problem but they copy the data row wise.

This question attempts the same problem in R.

I know this can be solved using a library like pandas, but I think there should be an easy way of doing it in Excel too.

 

Macro : Initial become Result

Is this a puzzle?

Are respondens meant to find out what the macro should do?

Are you thinking of Excel?

There are no A or B column markers in your table, only rows A, B, C, D.