Repeat range automatically without VBA

[miniadri]

Hello, first of all, thanks for your attention and your help.
Well, i'm going to try to explain what i want to do:
- I want an Excel to write some reports of my work and mates, and when i write one, excel should be repeat some cells automatically.
- The main problem is that i'm not allowed to use VBA or Macros in the computer because of IT and security, i can do it with VBA but i don't know how to do this things manually without Copy-Paste.


The range i want to repeat are A1:E5, when i fill for example "problema" or "solución", then automatically repeat range A1:E5 below the last one. This will continue until the end of the shift when we will save it as .pdf

I need some recomendations or other options without excel to get some control of the maintenance team

Thanks again.
Greetings, miniadri

[bsalv]

the attachment is invalid, use "go Advanced", scroll down to "Manage attachments" and select there your file

[miniadri]

Sorry, i didn't know why it didn't attached correctly, it suddenly dissapeared and i can't post urls yet

[TMS]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[bsalv]

The best way is copy/paste the whole range A1:E5 as many times as you want.
Without VBA copying borders and the use of merged cells is impossible.

[DJunqueira]

Mark the rows until row 6, grab the little dot on the bottom left with the mouse and go all the way down.

[ELeGault]

Simply type in =A1 into A7 Then drag this down a couple dozen times (As many as you need)... this will retain a relative reference of 6 above making any adjustment to A1-A5 instantly update without a macro. Dont over think it

EDIT - I spoke to soon.. This is still the solution but this time you will set A7 - A11 by doing as instructed above. Then you will type in =C5 into Cell C11 and finally =E5 into E11

Highlight A6:E11, Then drag the preset range down as many ref spaces that you need. Now if you update A1:A5, C5, or E5... all of the duplicated references will be updated


EDIT 2 : Fix the References. Lock them down or make them absolute... whatever really fits your data dictionary.

A7 should say =$A$1
A8 should say =$A$2
A9 Should Say = $A$3
A10 Should Say = $A$4
A11 Should Say = $A$5
C11 should Say = $C$5
E11 should Say = $E$5

Now that your absolute reference is written into A7:E11, Highlight A6:E11 and copy this down as many instances as you wish to have in your book/sheet.

All updates to labels should be done in the A1:E5 range. This is my final answer haha - is the best use of ref and least likely to get messed up if you remove boxes down the sheet later!