In the attached file, the code is in :
Sub copie_formules_redressement
LastRow is last row from sheet "données"
Within the same sub, I need to copy row 4 from sheet "données_redressées" down to the last row "LastRow".
Feel free to help but please keep in mind I am a newbie with VBA...
Thanks !
sorry here is the file
Hi and welcome to the forum
There was nothing attached.
To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks it is now attached sorry
Sorry but it's not clear (at least to me) what you expect to see as the result.
Would you add another sheet which shows what the results should look like?
Incidentally, rather than zip the workbook just upload it directly - it saves us having to unzip it.
I'm also interested to understand what task you are trying to accomplish with the system. The 'donnees' sheet seems quote complex and a rather strange way of keeping a database
Thank you for your reply, and sorry if it is not clear.
I've uploaded a smaller file, with less rows (I've kept 10 only in tab 'données')
The code should go in tab 'données' and find the lastrow, in variable LastRow.
Then it should go in tab 'données_redressées' and copy the formulas that are in row 4 down to LastRow (in this case row 10).
The formulas in row 4 should be are already there in the file.
Yes, the database is quite strange, and we will get rid of this at the end of 2019 for another better database.
Still somewhat puzzled
1. Are you building up a cumulative set of data in donnees redressees by copying whatever is in donnees to the bottom of donnees redressees?
2. The donnees redressees formulae are linked directly to their equivalent in the donnees sheet so that the two sheets are EXACTLY the same. Therefore why not just have a single sheet and add any new data to that sheet. Why do you need two sheets the same?
Thank you again...
No, not cumulative, and all lines in 'données' should be found in 'données_redressées'.
When I paste new data in 'données' and run the macro again, new lines should be found in 'données_redressées'.
Yes, the data in 'données_redressées' will mostly be the same than in 'données', but if you look carefully, there are some vlookups that search in tab 'Dossiers Événements' to show different data. Those columns are in orange.
So roughly, the code should find the number of lines with data in 'données' and then go in données_redressées in order to copy the formulas in row 4 until the last row with data.
In fact, each time I need to update this file, all the previous data is deleted and new data is pasted in 'données'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks