Hi,
I am using following code to store data in the next row starting from row 7 everytime I save.
My problem is that I have a formula in collumn 6 that`s prevent the storing of data to start in row 7.
Please Login or Register to view this content.
When I save a date in collumn 5, collumn 6 will show the same date next year. Is it possible to fix this in the code I am allready using?
Best regards
Øystein
Am not able to understand your question. Maybe you can help explain with the help of a sample file?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks for youre reply arlu,
I have attached a samplefile and a PDF to explane what to do.
You will also see the formulas I will use in collumn F and H.
Regards
Øystein
Eksempelfil Utstyr.xlsmSample information.pdf
You can calculate the lastrow using this
Then you can ask the code to populate the data from lastrow +1.Please Login or Register to view this content.
arlu1201,
This will not solv my problem. The code I am using no is working perfect to save data on the next line, but I need it to start saving data from row 7 even when several cells in the same row contains data.
Regards
Øystein
So each time you run the macro, it should only populate row 7 and overwrite the existing data?
Hi arlu,
No, I need to save the data on the next row every time. But as long as I have a formula in one of the collumns as now, it will not start saving the data from row 7.
Regards
Øystein
You need to calculate the lastrow using the column which does not have the formula. Then it will populate from row 7.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks