I have a spreadsheet that wa smade inoffice but when the operating system was upgraded to windows 11 all macros were removed .
So i need to re write these .
the idea is by clicking on a seperate button (marked stock) diffent colours in column 1 are found and a copy of the whole row is sent to another sheet on the spread sheet called stock .
I am a complete beginer i appologise if im saying somthing stupid
Last edited by MrProgrammer on Mon Apr 15, 2024 8:47 pm, edited 1 time in total.
Reason:Dropped: No changed document been uploaded -- MrProgrammer, forum moderator
I have a spreadsheet that was made in office but when the operating system was upgraded to windows 11 all macros were removed .
Then your macros was not stored inside the document. Always create backup copies of your important data, documents, macros, etc.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Your description of your macro is definitively vague.
You should check the documentation first, write as much as possible of the macro and then ask precise questions on blocking points.
If someone else wrote the macro and you just used it, it will be quite a challenge to rewrite it. Especially if you never wrote any macro at all.
Several topics in this forum with links to documentation. I have moved your post to the section about macros.
LibreOffice 24.2 on Xubuntu 24.04 and 7.6.4.1 portable on Windows 10
Have you tried the macro recorder - sounds like it might be able to do what you're asking, or some of it? How did you do them the first time as you talk about rewriting?
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Dellboy wrote: ↑Sun Mar 24, 2024 10:09 am
I have a spreadsheet that wa smade inoffice but when the operating system was upgraded to windows 11 all macros were removed .
Don't you have a backup of your user profile? I suspect that was where your macros were stored. Unless the macros were created or changed recently even an old backup would be of value to recover them.
Dellboy wrote: ↑Sun Mar 24, 2024 10:09 am
[criteria] are found and a copy of the whole row is sent to another sheet on the spread sheet called stock .
The forum has many topics about filtering data onto separate sheets. You can review them and read what others have done.
If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Hagar Delest wrote: ↑Sun Mar 24, 2024 11:59 am
Your description of your macro is definitively vague.
You should check the documentation first, write as much as possible of the macro and then ask precise questions on blocking points.
If someone else wrote the macro and you just used it, it will be quite a challenge to rewrite it. Especially if you never wrote any macro at all.
Several topics in this forum with links to documentation. I have moved your post to the section about macros.
Indeed i did write the question very badly . perhaps adding a sample of the spread sheet would help explain it .
column c has colours in it i wish to sort each colour and insert into a seperate sheet on the spreadsheet therby giving reports on stock and sales etc .
Originally this was done by clicking in a cell marked 'sales' 'stock' etc the imformation then listed into a seperate sheet .
Documents you post should have sensitive information removed.
Column c only has green or no color in it.
By a separate sheet you seem to mean a sheet in a different document? Perhaps you could make a simple version (with sensitive information removed) of part of the original and the matching result sheet?
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
JeJe wrote: ↑Sun Mar 24, 2024 6:09 pm
Documents you post should have sensitive information removed.
Column c only has green or no color in it.
By a separate sheet you seem to mean a sheet in a different document? Perhaps you could make a simple version (with sensitive information removed) of part of the original and the matching result sheet?
The edited part sent indeed has one colour so sent a larger selection with imformation changed for security (as was the first one .Sheet on the same document is what is required
Hope you can come up with the answer