[Solved] If cell contains 1 then copy row to another sheet
-
- Posts: 1
- Joined: Mon Jan 17, 2022 7:04 pm
[Solved] If cell contains 1 then copy row to another sheet
I have been watching videos and trying to understand how to Copy entire row to another sheet if a cell on first sheet equals specified number. any help is appreciated.
Last edited by Hagar Delest on Sat Feb 19, 2022 1:35 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 3.1 on windows 10
- MrProgrammer
- Moderator
- Posts: 5279
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Help:IF cell contains 1 then copy to another sheet
[Solved] Copying only marked rows to another sheetgrasstrimmer379 wrote:Copy entire row to another sheet if a cell on first sheet equals specified number
[Solved] Populate multiple sheets from master sheet
There are dozens of similar topics if you search a bit.
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.
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.6, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.7.6, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
-
- Posts: 335
- Joined: Sun Sep 06, 2020 8:27 am
Re: If cell contains 1 then copy row to another sheet
And a special option are advanced filters,
wich can copy all lines to another area, if they meet defined criteria.
https://help.libreoffice.org/latest/is/ ... ilter.html
wich can copy all lines to another area, if they meet defined criteria.
https://help.libreoffice.org/latest/is/ ... ilter.html
LibreOffice 7.6 on Windows 10pro and other Versions parallel